"Tom Lane" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> "Nick Fankhauser" <[EMAIL PROTECTED]> writes:
> > Does PostgreSQL support (or some day will support) "partitioned tables"?
>
> It's not on anyone's radar screen AFAIK.
>
> > Alternately, does anyone hav
Is it possible to change the ownership of a table or database? Can I modify
pg_class and pg_database directly to do this?
--
--
The information contained in this message (including any attachments)
is confidential and intended so
Jeremy Ashcraft wrote:
>
> I'm running PG7.0.2 on Solaris8 and am experiencing a problem with child
> procs hanging around long after their queries have finished. We're using PG
> in conjuction with Enhydra application server. I'm wondering if this is a
> known bug of some sort with Solaris or
Garry Dolley wrote:
>
> > Hmm, all the crashes you show us below sound like resource exhaustion
> > issues. That's a nice way to say your feeding silly SQL to the server,
> > and it's _trying_ to do what you ask... How are you driving the server?
> > psql? some sort of CGI? We need more info to h
In case anyone is still interested, I was able to improve the load considerably
by wrapping a group of 10-15 INSERTS into a single transaction. I didn't know
that each insert/query not explicitly wrapped in a transaction got it's own
transaction (and the associated overhead) by default.
Load is n
"Hernan J. Gonzalez" wrote:
>
> -- Brian Baquiran <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I'm using Postgres 6.5.2 in a high-volume
> > application that has on the order of a
> > hundred inserts and selects (but mostly inserts) a
> &
Hi,
I'm using Postgres 6.5.2 in a high-volume application that has on the order of a
hundred inserts and selects (but mostly inserts) a minute. My loadaverage hovers
around 1.0, and can go much, much higher (50-80) during vacuum and queries on
fairly large tables (1M rows). This is on a 4-CPU Int
We had problems with postgres when using ODBC (in Acess97), this message
comes out on the console:
FATAL 1: Memory exhausted in AllocSetAlloc()
pq_recvbuf: unexpected EOF on client connection
Is there a tweak we can do? This is the 6.4 release.
Thanks,
Brian
--
[EMAIL PROTECTED]
http://www.baq
I'm talking with the boss about Postgres and the conversation turned to
security. What kind of security features does Postgres have? I'm aware of the
host-based authentication in pg_hba.conf. Are the actual connections to the
database (SQL queries and what they return) encrypted?
Thanks,
Brian
--
