Jim Nasby writes:
> Oh, and in my 28 table case ru_minflt was 428 4k memory pages (1.7MB). Not a
> great measurement, but better than nothing. I didn't detect anything
> noticeable on vmstat either, so I don't think the consumption is huge (an
> email in the older thread mentioned 1GB... I'm no
On 10/30/13 5:27 PM, Jim Nasby wrote:
On 10/29/13 3:36 PM, Tom Lane wrote:
Jim Nasby writes:
Is there a way to measure memory consumption during planning, short of
something like strace? (I've got no dev tools available on our servers.)
Nothing built-in, I'm pretty sure. You could probably
On 10/29/13 3:36 PM, Tom Lane wrote:
Jim Nasby writes:
Is there a way to measure memory consumption during planning, short of
something like strace? (I've got no dev tools available on our servers.)
Nothing built-in, I'm pretty sure. You could probably add some
instrumentation, but that wou
Ben,
> A couple of questions about the ADD CONSTRAINT. The foreign key column
> on the local table is indexed, and there are only ~50 unique values,
> so the db *could* come up with the unique values pretty quickly and
> then check them.
This would indeed be a nice optimization, especially now th
I'm not sure if its suppose to be under general so please let me know if I
need to move it to another topic area please.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/postgres-connections-tp5776349p5776383.html
Sent from the PostgreSQL - performance mailing list archi
