Michael,
Thanks a lot.
http://developer.postgresql.org/docs/postgres/planner-stats-details.html
is very useful for me.
However, if I can be provided some specific functions to get rows count,
That will be greatly appreciated.
Basically, I want to query data dictionary to get the estimated
number
On Fri, Jul 29, 2005 at 11:54:18AM -0600, Lee Wu wrote:
> explain select count(*) from pg_class where relname='pg_class';
> QUERY PLAN
> --
> Aggregate (cost=4.55..4.55 rows=1 width=0)
>-> Seq Scan on pg_cl
Hi all,
I want to find out how PG gets rows when it explains a
query.
For example, when I issue:
explain select count(*) from pg_class where
relname='pg_class';
QUERY PLAN
--
Aggregate (cost=
hello.I use postgresql 8.0 . I've created the server.key and
server.crt in this manner:
openssl req -new -nodes -keyout server.key -out server.csr
openssl req -x509 -key /home/data/server.key -in /home/data/server.csr -out
server.crt
and I put theese in my data home.
I launch postgres in t
We're going to build a new server with a bit more RAM -- 8 gigs.
I know memory is somehow the bottleneck, but I don't think it's because I
have too little. Performance monitors show a lot of swap activity during
heavy query load testing, but available RAM is never maxed out, or even
close. SOMETHI
Steve Lane wrote:
All:
We have a postgres 7.4 server where we're trying to achieve some speedups.
Right now, at least superficially, RAM appears to be the bottleneck -- lots
of swaps in and out.
There is another consultant beside myself in the mix and he asked this
question: can we put the dat
Steve Lane <[EMAIL PROTECTED]> writes:
> Or will postgres 8 rebuild an index if it doesn't find it where it expects?
No, but there's always REINDEX.
> I recognize, or think I do, that PG 8 tablespaces would be required to
> accomplish this.
It'd certainly make it a lot easier. Also, it's probab
> RAM appears to be the bottleneck -- lots
> of swaps in and out.
> can we put the database indexes on a RAM disk?
Can you increase the RAM in the machine? I guess I should assume you're
maxed out.
Rick
[EMAIL PROTECTED] wrote on 07/29/2005 10:32:28 AM:
> All:
>
> We have a postgres 7.4 server
On Fri, 2005-07-29 at 08:24, Kailash Vyas wrote:
> hi
>
> i am optmizing postgres database and need some help on it.
> I currently have a server with 2 Gb RAM.
>
> I have setup the /proc/sys/kernel/shmall and /proc/sys/kernel/shmmax
> to 536870912 i.e 512 Mb.
> should i change it to 2 Gb and how
All:
We have a postgres 7.4 server where we're trying to achieve some speedups.
Right now, at least superficially, RAM appears to be the bottleneck -- lots
of swaps in and out.
There is another consultant beside myself in the mix and he asked this
question: can we put the database indexes on a RA
Guido Barosio wrote:
> Thought that v8 started with default tcp availability.
It is _enabled_ by default for connections, but local clients don't use
tcp by default.
---
>
> G.
>
> On 7/29/05, Tom Lane <[EMAIL PROTECTED]>
Thought that v8 started with default tcp availability.
G.On 7/29/05, Tom Lane <[EMAIL PROTECTED]> wrote:
=?GB2312?B?zfXP/ruq?= <[EMAIL PROTECTED]> writes:> /usr/local/pgsql/bin/postmaster -o "-i" -D /usr/local/pgsql/dataThat should be just /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/da
On Fri, Jul 29, 2005 at 09:48:28AM -0400, Chris Hoover wrote:
> Subject pretty much says it all. Is there a way in a sql query to
> have it return the server name and/or the server ip address of the
> PostgreSQL server?
Depends on the version of PostgreSQL. In 8.0 you can use
inet_server_addr():
Chris Hoover wrote:
> Subject pretty much says it all. Is there a way in a sql query to
> have it return the server name and/or the server ip address of the
> PostgreSQL server?
8.0 has such informix via functions:
test=> \df *server*
List of fu
=?GB2312?B?zfXP/ruq?= <[EMAIL PROTECTED]> writes:
> /usr/local/pgsql/bin/postmaster -o "-i" -D /usr/local/pgsql/data
That should be just
/usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data
You seem to be confusing pg_ctl syntax with postmaster syntax.
regards,
Subject pretty much says it all. Is there a way in a sql query to
have it return the server name and/or the server ip address of the
PostgreSQL server?
thanks,
Chris
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
sql `set enable_seqscan to off;` may help here?
Regards,
g
On 7/29/05, John Abel <[EMAIL PROTECTED]> wrote:
Hi,The company I'm at is running dbmirror, and we've found a problem withclean_pending,pl, in that it takes an age to run. I've done somelooking about, and came with up this:
http://www.po
hi
i am optmizing postgres database and need some help on it.
I currently have a server with 2 Gb RAM.
I have setup the /proc/sys/kernel/shmall and /proc/sys/kernel/shmmax to 536870912 i.e 512 Mb.
should i change it to 2 Gb and how will it affect the perfomance and
will there be any downsides to
On Tue, 2005-07-26 at 23:22 +0100, Simon Riggs wrote:
> If I have a system that writes out one WAL file every 5 minutes, and I
> have these settings:
>
> checkpoint_timeout = 3329
> checkpoint_segments = 1000
> (parameters checked as valid via pg_settings)
>
> How many WAL files would you expect
hi
I need some information to optimize the postgres database server (7.3.10).
I have 2 Gb RAM on the server.
I have set the /proc/sys/kernel/shmmax and /proc/sys/kernel/shmall to 536870912 (512 Mb)
should i set the shmmax and shmall to use 2 GB or it is better to keep it less.
also how does
Hi,
On Thu, 28 Jul 2005, Gregory Zelesnik wrote:
Actually, I do not have postgresql-libs v8.0.2 installed:
[EMAIL PROTECTED] downloads]$ rpm -qa | grep postgres
rh-postgresql-devel-7.3.6-7
rh-postgresql-tcl-7.3.6-7
postgresql-docs-8.0.3-1PGDG
rh-postgresql-pl-7.3.6-7
rh-postgresql-libs-7.3.6-
Hi,
On Fri, 29 Jul 2005, ararant wrote:
Is there a way of installing PostgreSQL 8.0.3 not by
compiling the source code and not by using rpm? Is there
binary files (already compiled) for installation?
Installing PostgreSQL in these two ways cause many problems
with missing libraries and/or file
Hi,
The company I'm at is running dbmirror, and we've found a problem with
clean_pending,pl, in that it takes an age to run. I've done some
looking about, and came with up this:
http://www.postgresql.org/docs/7.4/interactive/indexes.html
After reading the comments on that page, I explain'd
On Fri, Jul 29, 2005 at 03:30:23 -0300,
ararant <[EMAIL PROTECTED]> wrote:
> Is there a way of installing PostgreSQL 8.0.3 not by
> compiling the source code and not by using rpm? Is there
> binary files (already compiled) for installation?
> Installing PostgreSQL in these two ways cause many pro
24 matches
Mail list logo
