Cardoso Patrick wrote:
Hi,
Is it possible to know the number of users connected to a database ?
select * from pg_stat_activity.
I'm not sure about permissions you need for it, try.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the plan
On Fri, 2004-07-16 at 10:42, Cardoso Patrick wrote:
> Hi,
>
> Is it possible to know the number of users connected to a
> database ?
>
> Regards
>
>
select * from pg_stat_activity;
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---
On Mon, 2004-07-19 at 13:25, Bill Chandler wrote:
> Hello,
>
> I'm sorry if this too basic. I searched the web but
> could not find an answer.
>
> Q1: When you do a VACUUM ANALYZE does it update the
> statistics for existing indexes on the table? Or do
> you have to do an explicit REINDEX comma
On Mon, 2004-07-19 at 13:28, Kris Kiger wrote:
> I've got a database that is a single table with 5 integers, a timestamp
> with time zone, and a boolean. The table is 170 million rows in length.
> The contents of the tar'd dump file it produced using:
> pg_dump -U postgres -Ft test > test_b
Kris Kiger <[EMAIL PROTECTED]> writes:
> I've got a database that is a single table with 5 integers, a timestamp
> with time zone, and a boolean. The table is 170 million rows in length.
> The contents of the tar'd dump file it produced using:
> pg_dump -U postgres -Ft test > test_backup.ta
Hello,
I'm sorry if this too basic. I searched the web but
could not find an answer.
Q1: When you do a VACUUM ANALYZE does it update the
statistics for existing indexes on the table? Or do
you have to do an explicit REINDEX command on the
index (or possibly drop and recreate the index)?
thanks
I've got a database that is a single table with 5 integers, a timestamp
with time zone, and a boolean. The table is 170 million rows in length.
The contents of the tar'd dump file it produced using:
pg_dump -U postgres -Ft test > test_backup.tar
is: 8.dat (approximately 8GB), a toc, and resto
On Mon, 19 Jul 2004, Tsirkin Evgeny wrote:
> But this way i will touch both the schema AND data
> And what i want is to change the schema ONLY.
The use the ALTER TABLE table* ADD COLUMN syntax to alter
the schema for table and its descendants.
In general, SQL_INHERITANCE=false is primarily there
But this way i will touch both the schema AND data
And what i want is to change the schema ONLY.
Thanks
On Sun, 18 Jul 2004, Stephan Szabo wrote:
> On Tue, 13 Jul 2004, evgeny tsurkin wrote:
>
> > Hi All!
> > That probably was already asked thousand times
> > but i did not find an exact answer:
