Saurabh Dave 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 performed, and a s
On Sun, Jul 5, 2009 at 11:48 PM, Saurabh Dave 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 to be adjusted
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 wrote:
> Saurabh
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
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 o
>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 pa
Mark Mielke 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. Specifically,
> you are pro
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 sp
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.
Is
