On Fri, 20 Oct 2000, pgsql-admin wrote:
> however i got one problem (see below)... but when i started the psql
> monitor again,
> it did not appear. i'm worried that it would happen again.
>
> applieddata=> SELECT COUNT(*) FROM office, office_application
> applieddata-> WHERE office.code = offi
[EMAIL PROTECTED] writes:
>On Fri, 20 Oct 2000, pgsql-admin wrote:
>
>> The postgres server was started with the command:
>> /usr/bin/postmaster -i -S -D/var/lib/pgsql
>
>Have you tried changing the values of -B to see if increasing the
>number of buffers helps?
tried it already. i start postmast
On Fri, 20 Oct 2000, pgsql-admin wrote:
> The postgres server was started with the command:
> /usr/bin/postmaster -i -S -D/var/lib/pgsql
Have you tried changing the values of -B to see if increasing the
number of buffers helps?
> Here is just one query executed from Embperl pages with Perl DBI:
The postgres server was started with the command:
/usr/bin/postmaster -i -S -D/var/lib/pgsql
Here is just one query executed from Embperl pages with Perl DBI:
officedata=> explain SELECT * FROM office, office_application
officedata-> WHERE office.code = office_application.office_code
officedata->
We'll probably need some additional information:
What settings did you start the server with, what queries are you running
that are slow (with schema, index information), what does explain show for
the queries?
Stephan Szabo
[EMAIL PROTECTED]
On Thu, 19 Oct 2000, pgsql-admin wrote:
> I'm usin
I'm using
PostgreSQL 6.5.3 on i686-pc-linux-gnu.
I have a backup of our database (sql dump and large object)
backup.tar.bz2 with the size of 10121985.
We have users accessing our database from http and
odbc (ms excel).
Can someone pls tell how to solve this problem?
Thank you very much.
Sherwi