On Sun, Jul 5, 2009 at 11:48 PM, Saurabh Davesaurabhd...@gmail.com wrote:
Hi,
We are bundling PostgreSQL 8.3.7 with our Java based application.
We observe that in some systems the Database access becomes very slow after
running it for couple of days.
We understand that postgresql.conf needs
Saurabh Dave saurabhd...@gmail.com wrote:
what I need to do is to check the queries that are slow and do a
vacuum analyze and share the results along with postgresql.conf
being used.
Hopefully just a typo there. While you need to ensure that adequate
VACUUM and ANALYZE maintenance is being
Mark Mielke mark 'at' mark.mielke.cc writes:
On 07/06/2009 01:48 AM, Saurabh Dave wrote:
We are bundling PostgreSQL 8.3.7 with our Java based application.
[...]
PostgreSQL 8.4 comes with significantly improved out of the box
configuration. I think that is what you are looking for.
No offense intended - but have you looked at the documentation for
postgresql.conf?
If you are going to include PostgreSQL in your application, I'd highly
recommend you understand what you are including. :-)
I had a look into the documentation of postgres.conf, and tried a lot with
changing
On 07/06/2009 03:17 AM, Saurabh Dave wrote:
No offense intended - but have you looked at the documentation for
postgresql.conf?
If you are going to include PostgreSQL in your application, I'd
highly recommend you understand what you are including. :-)
I had a look into the documentation of
Saurabh Dave wrote:
No offense intended - but have you looked at the
documentation for postgresql.conf?
If you are going to include PostgreSQL in your application, I'd
highly recommend you understand what you are including. :-)
I
had a look into the documentation of postgres.conf,
Thanks all for your valuable comments, as I gather, what I need to do is to
check the queries that are slow and do a vacuum analyze and share the
results along with postgresql.conf being used.
I will work on that.
Thanks again,
Saurabh
On Tue, Jul 7, 2009 at 4:46 AM, justin
Hi,
We are bundling PostgreSQL 8.3.7 with our Java based application.
We observe that in some systems the Database access becomes very slow after
running it for couple of days.
We understand that postgresql.conf needs to be adjusted as per the system
specification where postgreSQL is running.
On 07/06/2009 01:48 AM, Saurabh Dave wrote:
We are bundling PostgreSQL 8.3.7 with our Java based application.
We observe that in some systems the Database access becomes very slow
after running it for couple of days.
We understand that postgresql.conf needs to be adjusted as per the
system
