dbTalk Databases Forums  

[BUGS] BUG #1675: very slow work

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #1675: very slow work in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dimitar
 
Posts: n/a

Default [BUGS] BUG #1675: very slow work - 05-19-2005 , 08:29 AM







The following bug has been logged online:

Bug reference: 1675
Logged by: Dimitar
Email address: dmitar (AT) cablebg (DOT) net
PostgreSQL version: 8.0.2 win32
Operating system: Windows Server 2003: Web Edition
Description: very slow work
Details:

Posgre works slower on Wndows than on Linux. We worked previously with
Posgre on Linux and it's over 100 times faster than Windows.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Reply With Quote
  #2  
Old   
Michael Fuhr
 
Posts: n/a

Default Re: [BUGS] BUG #1675: very slow work - 05-19-2005 , 05:34 PM






On Thu, May 19, 2005 at 01:27:17PM +0100, Dimitar wrote:
Quote:
Posgre works slower on Wndows than on Linux. We worked previously with
Posgre on Linux and it's over 100 times faster than Windows.
Could you provide more information about what you're doing? Are
you running comparable queries against a comparable data set on
comparable hardware with a comparable database configuration? Have
you vacuumed and analyzed the database? Could you post the EXPLAIN
ANALYZE output from an example query that's 100 times faster on
Linux? If you still have a Linux system then please post the EXPLAIN
ANALYZE output from both systems so we can see the difference.

This thread might be more appropriate in pgsql-performance until
there's more evidence that the performance difference is indeed a
PostgreSQL bug and that other possibilities have been investigated
and ruled out.

BTW, it's "PostgreSQL" or "Postgres", not "Posgre".

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.