pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
postgresql 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>
  2003-12-22 22:32 ` Re: postgresql performance on linux port Tom Lane <tgl@sss.pgh.pa.us>
  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 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   ` Re: postgresql performance on linux port 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-22 19:11 postgresql performance on linux port Michael Guerin <guerin@rentec.com>
  2003-12-22 22:32 ` Re: postgresql performance on linux port Tom Lane <tgl@sss.pgh.pa.us>
@ 2003-12-23 00:33   ` Michael Guerin <guerin@rentec.com>
  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