pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgresql performance on linux port
3+ messages / 2 participants
[nested] [flat]
* postgresql performance on linux port
@ 2003-12-22 19:11 Michael Guerin <guerin@rentec.com>
0 siblings, 1 reply; 3+ messages in thread
From: Michael Guerin @ 2003-12-22 19:11 UTC (permalink / raw)
To: pgsql-performance
I just restored a database running on a solaris box to a linux box
and queries take forever to execute. The linux box is faster and has
twice the memory allocated to postgresql, is there anything obvious that
I should look at? It is using a journal file system.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postgresql performance on linux port
@ 2003-12-22 22:32 Tom Lane <tgl@sss.pgh.pa.us>
parent: Michael Guerin <guerin@rentec.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2003-12-22 22:32 UTC (permalink / raw)
To: Michael Guerin <guerin@rentec.com>; +Cc: pgsql-performance
Michael Guerin <guerin@rentec.com> writes:
> I just restored a database running on a solaris box to a linux box
> and queries take forever to execute.
Did you remember to run ANALYZE? Have you applied the same
configuration settings that you were using before?
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postgresql performance on linux port
@ 2003-12-23 00:33 Michael Guerin <guerin@rentec.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Michael Guerin @ 2003-12-23 00:33 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-performance
Hi Tom,
I don't believe I did run Analyze, I was under the assumption that the
statistics would have been up to date when the indexes were created.
Thanks for the quick response.
-mike
Tom Lane wrote:
> Michael Guerin <guerin@rentec.com> writes:
> > I just restored a database running on a solaris box to a linux box
> > and queries take forever to execute.
>
> Did you remember to run ANALYZE? Have you applied the same
> configuration settings that you were using before?
>
> regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-12-23 00:33 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-12-22 19:11 postgresql performance on linux port Michael Guerin <guerin@rentec.com>
2003-12-22 22:32 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-12-23 00:33 ` Michael Guerin <guerin@rentec.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox