On Wed, 22 Jan 2003, Michael Paesold wrote:
> Achilleus Mantzios <[EMAIL PROTECTED]> wrote:
>
> > For a) do all the necessary tuning on PostgreSQL.
> > With 1GB of Mem, you could set a value of shared_buffers to 10.
>
> Perhaps just a type, but that is way to much! It would mean about 800 Mb
>
Michael Hostbaek wrote:
Hi,
I am running postgresql 7.2.3 on a test server (with potential of
becoming my production server).
On the server I have a perl script, that is grabbing some data from a
inventory database (local) - with some subselects.
The query is like this:
my $sth = $ppdb->prepa
Michael Hostbaek wrote:
Tomasz Myrta (jasiek) writes:
3. Explain analyze would be helpful like in most performance cases...
The same with SQL query instead of Perl script.
Explain analyze:
NOTICE: QUERY PLAN:
Limit (cost=27.55..27.55 rows=1 width=183) (actual
time=35364.89..35365.04 row
Tomasz Myrta (jasiek) writes:
>
> 3. Explain analyze would be helpful like in most performance cases...
> The same with SQL query instead of Perl script.
Explain analyze:
NOTICE: QUERY PLAN:
Limit (cost=27.55..27.55 rows=1 width=183) (actual
time=35364.89..35365.04 rows=10 loops=1)
-> Sor
Achilleus Mantzios <[EMAIL PROTECTED]> wrote:
> For a) do all the necessary tuning on PostgreSQL.
> With 1GB of Mem, you could set a value of shared_buffers to 10.
Perhaps just a type, but that is way to much! It would mean about 800 Mb
shared buffers! I would rather suggest a value between 1
On Wed, 22 Jan 2003, Michael Hostbaek wrote:
> Hi,
I would suggest looking at the problem in three directions:
a) PostgreSQL system wise
b) PostgreSQL sql wise
c) FreeBSD wise.
For a) do all the necessary tuning on PostgreSQL.
With 1GB of Mem, you could set a value of shared_buffers to 10.
Hi,
I am running postgresql 7.2.3 on a test server (with potential of
becoming my production server).
On the server I have a perl script, that is grabbing some data from a
inventory database (local) - with some subselects.
The query is like this:
my $sth = $ppdb->prepare("
select partno, cr
