the output of 'show all;' so you can advice me in any
other configuration settings that I might need to change to perform
better.
Thank you very much for your feedback and all of your help!
lefteris sidirourgos
P.S. sorry if you get this message twice but the first one does not
appear to have
rows=52484047 loops=1)
I dont see the seq scan to ba a problem, and it is the correct choice
here because Year spans from 1999 to 2009 and the query asks from 2000
and on, so PG correctly decides to use seq scan and not index access.
lefteris
On Thu, Jan 7, 2010 at 2:32 PM, A. Kretschmer
% consumption of main memory. There is no way to force sort to use
say blocks of 128MB ? wouldn't that make a difference?
lefteris
p.s. i already started the analyze verbose again as Flavio suggested
and reset the parrameters, although I think some of Flavioo's
suggestions have to do with multiple
only have one session with one connection, do I have like many
reader workers or something?
Thank you and sorry for the plethora of questions, but I know few
about the inner parts of postgres:)
lefteris
On Thu, Jan 7, 2010 at 3:05 PM, Jochen Erwied
joc...@pgsql-performance.erwied.eu wrote
On Thu, Jan 7, 2010 at 3:51 PM, Ivan Voras ivo...@freebsd.org wrote:
On 7.1.2010 15:23, Lefteris wrote:
I think what you all said was very helpful and clear! The only part
that I still disagree/don't understand is the shared_buffer option:))
Did you ever try increasing shared_buffers to what
On Thu, Jan 7, 2010 at 4:57 PM, Ivan Voras ivo...@freebsd.org wrote:
2010/1/7 Lefteris lsi...@gmail.com:
On Thu, Jan 7, 2010 at 3:51 PM, Ivan Voras ivo...@freebsd.org wrote:
On 7.1.2010 15:23, Lefteris wrote:
I think what you all said was very helpful and clear! The only part
that I still
times I got from postgres.
I really appreciate your help! this is a great opportunity for me to
get some feeling and insights on postgres since I never had the chance
to use it in a large scale project.
lefteris
On Thu, Jan 7, 2010 at 11:21 PM, Greg Smith g...@2ndquadrant.com wrote:
Lefteris
On Thu, Jan 7, 2010 at 11:57 PM, Lefteris lsi...@gmail.com wrote:
Hi Greg,
thank you for your help. The changes I did on the dataset was just
removing the last comma from the CSV files as it was interpreted by pg
as an extra column. The schema I used, the load script and queries can
be found
Hi,
I first suggestion would be to either build the index only on
parcel_id_code or on (parcel_id_code, id).
But I am not sure because I am new in pg:)
cheers,
lefteris
On Sat, Jan 9, 2010 at 1:46 PM, Richard Neill rn...@cam.ac.uk wrote:
Dear All,
I'm trying to optimise the speed of some