a 50.000 Euro senza
spese in pochissimo tempo. Richiedi Informazioni
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=7371d=20080103
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating
Hi
I need to get PGDATA location when I logged in as non-postgres user.
I cannot see data_directory from pg_setting table as non-postgres user.
Any work around? Any other way to retrieve that information?
If not, what is the quickest way to enable non-postgres user to have
PGDATA
Am Donnerstag, 3. Januar 2008 schrieb Sofer, Yuval:
I need to get PGDATA location when I logged in as non-postgres user.
Consider writing a security-definer function that retrieves the information.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of
Hi,
I have a pretty live table: rows being inserted and updated more
than once 1 per second, though far, far more inserts than updates.
There are currently over 3 million rows.
It has not been vacuumed for months.
Now a vacuum on that table takes hours, and I have not let it complete
because
If you're using the version 8.1 and after, you should consider using the
auto-vacuum daemon that is the best way to do it:
http://www.postgresql.org/docs/8.1/static/maintenance.html
Pascal;
Brian Modra a écrit :
Hi,
I have a pretty live table: rows being inserted and updated more
than once 1
Hey Tom, Shane,
actually, PHP w/out the PG stuff builds just fine with x86_64 and i386
specified at the same time. I didn't bother with the PPC
architectures, since I don't have a Leopard capable PPC box any more.
My old PowerBook G3/500 point blank refuses to run anything higher
than
Chris Ruprecht wrote:
Hey Tom, Shane,
I'm good to run with the x86_64 only binary since my Apache is built
using that architecture.
That's not a real reason to run pg in 64 bit.
Although you would need php and libpq to be the same architecture as
apache (the running architect if multiple
Hi Team,
I am using Postgresql 7.4.2 version on Solaris. There are number of
tables say about 30+ tables in our database. I started to reindex the
tables individually. reindex table table name. All the queries
executed normally with less than 1 minute of duration. But one table is
not
Chris Browne wrote:
- Alternatively, to help establish common policies, for the less
frequent cases.
env: Sets up PATH, MAN_PATH, PGPORT with the values used by
the backend in this init file
How does this work? I have my own script to do things, and one of the
painful
On Jan 3, 2008 5:33 AM, Suresh Gupta VG [EMAIL PROTECTED] wrote:
Hi Team,
I am using Postgresql 7.4.2 version on Solaris.
You need to update to 7.4.18 or whatever the last version was. 7.4.2
has known data eating bugs, and if you value your data even a little,
you should update. this is a
On Jan 3, 2008 6:48 AM, Brian Modra [EMAIL PROTECTED] wrote:
Hi,
I have a pretty live table: rows being inserted and updated more
than once 1 per second, though far, far more inserts than updates.
There are currently over 3 million rows.
It has not been vacuumed for months.
How many rows
On 03.01.2008, at 05:48, Brian Modra wrote:
I have a pretty live table: rows being inserted and updated more
than once 1 per second, though far, far more inserts than updates.
Not that busy ;-)
It has not been vacuumed for months.
Not good.
Now a vacuum on that table takes hours, and I
Hi,
thanks for your reply.
The number of rows per second has been increasing rapidly, but its
averaging about 1 row per second, and a far smaller number of updates.
So maybe there are not such a huge number of dead rows. I hope that a
normal vacuum will clean it up.
Total number of rows is about 3
James Cloos [EMAIL PROTECTED] writes:
Right after the restore the db took up less than ten percent as much
space as the backup. (For the backup I stopped pg and used rsync on
the /var/lib/postgresql/data directory.)
Why was the db using that extra five plus gigs?
Smells like a
14 matches
Mail list logo