Alvaro Herrera wrote:
Hackers,
Here is a first cut at autovacuum integration. Please have a look at
it. Note that this patch automatically creates three new files:
Couple more things that I didn't think about while we were talking about
this the other day.
XID wraparound: The patch a
On Wed, Jun 29, 2005 at 11:44:58PM -0400, Tom Lane wrote:
> (BTW: Alvaro, I've been having direct mail to you bounce lately ---
> let's see if this goes through ...)
Yeah, sorry about that :-( I realized I must change mail provider ASAP
when I noticed it's been eating my own emails (e.g. the aut
Alvaro Herrera wrote:
There are several things that are painfully evident with this thing on:
- TRUNCATE does not update stats. It should send a stat message to
which we can react.
How important is this really? The stats from before the truncate might
be ok, especially since they might
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> we can possibly gain custom format full cluster dumps.
Do we care? The main rationale for inventing a custom format, as I
recall it, was (a) plain text couldn't hack blobs and (b) you needed
the ability to rearrange the dump order to work arou
The trick in hacking pg_dump is to understand which layer you need to
modify. The whole thing seems overly complex to me :-( ... but
redesigning it is a project for another release cycle.
I just find the whole BLOB handling very tricky to understand :(
I vote that we combine pg_dumpall and pg_
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Wed, Jun 29, 2005 at 11:05:43PM -0400, Tom Lane wrote:
>> That's pretty icky :-(. I think the right way is more like this.
> Wow, that's complex. No wonder I wasn't able to come up with a patch to
> dump ALTER DATABASE commands some time ago.
The
In the course of looking into Larry's buildfarm woes, I found that
Unixware needs this patch on HEAD to build correctly
cheers
andrew
Index: src/backend/utils/adt/timestamp.c
===
RCS file: /projects/cvsroot/pgsql/src/backend/uti
Attached patch enables dumping of LOB comments when in text mode.
I really don't get the binary/custom format LOB stuff (and don't have
time to investigate), so perhaps someone else can do that.
That's pretty icky :-(. I think the right way is more like this.
Hehe - in the world of open sou
On Wed, Jun 29, 2005 at 11:05:43PM -0400, Tom Lane wrote:
> Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> > Attached patch enables dumping of LOB comments when in text mode.
> > I really don't get the binary/custom format LOB stuff (and don't have
> > time to investigate), so perhaps someo
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> Attached patch enables dumping of LOB comments when in text mode.
> I really don't get the binary/custom format LOB stuff (and don't have
> time to investigate), so perhaps someone else can do that.
That's pretty icky :-(. I think the right w
Tom Lane wrote:
Since both allocations are only transient within this routine, there's
a simpler more effective solution, which is to only do one malloc in
the first place
Yeah, true. Attached is a revised patch -- committed to HEAD.
-Neil
Index: src/interfaces/libpq/fe-auth.c
Hackers,
(Resend, like fifth time or so. bzip2'ing the patch for luck.)
Here is a first cut at autovacuum integration. Please have a look at
it. Note that this patch automatically creates three new files:
src/backend/postmaster/autovacuum.c
src/include/catalog/pg_autovacuum.h
src/include/post
Andreas Pflug <[EMAIL PROTECTED]> writes:
> I'm not really happy that all functions change their names (more
> versioning handling in pgadmin), but pg_storage_size is certainly the
> most precise name.
Actually, it seems excessively imprecise to me: the name conveys nothing
at all to help you re
Bruce Momjian wrote:
Yea, but then we have toast and we would need another name. I suggested
pg_storage_size() because it relates to a storage unit (index, toast,
etc), and not a real object or relation.
I'm not really happy that all functions change their names (more
versioning handling i
Greetings,
Attached please find a patch to change how the permissions checking
for alter-owner is done. With roles there can be more than one
'owner' of an object and therefore it becomes sensible to allow
specific cases of ownership change for non-superusers.
The permission checks for
Neil Conway <[EMAIL PROTECTED]> writes:
> The attached patch fixes a theoretical memory leak in libpq: if the
> second malloc() fails due to OOM, the memory returned by the first
> (successful) malloc() will be leaked.
Since both allocations are only transient within this routine, there's
a simp
Sergej Sergeev said:
> Bruce Momjian wrote:
>
>>Sergej, are you going to repost this patch?
>>
>>
> Sorry for delaying.
> Yes, I working on it, but I wait for decision about Andrew and Abhijit
> patches.
>
This is the polymorphic types plus perl to pg array patch, right?
I am not working on this
Michael Paesold wrote:
> > Do we have to use pg_object_size? Is there a better name? Are
> > indexes/toasts even objects?
>
> Relation is not an ideal names, but I heard people talk about heap relation
> and index relation. Indexes and tables (and sequences) are treated in a
> similar way quit
Dave Page wrote:
>
>
>
> -Original Message- From: Bruce Momjian
> [mailto:[EMAIL PROTECTED] Sent: Wed 6/29/2005 2:16 AM To: Dave
> Page Cc: PostgreSQL-patches; PostgreSQL-development Subject: Re:
> [PATCHES] Dbsize backend integration
>
> > OK, so you went with relation as heap/index/to
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: Wed 6/29/2005 2:16 AM
To: Dave Page
Cc: PostgreSQL-patches; PostgreSQL-development
Subject: Re: [PATCHES] Dbsize backend integration
> OK, so you went with relation as heap/index/toast only, and table as the
> total
The attached patch implements spi_query() and spi_fetchrow() functions
for PL/Perl, to avoid loading the entire result set into memory as the
existing spi_exec_query() function does.
Here's how one might use the new functions:
$x = spi_query("select ...");
while (defined ($y = spi_fetchro
The attached patch fixes a theoretical memory leak in libpq: if the
second malloc() fails due to OOM, the memory returned by the first
(successful) malloc() will be leaked.
Barring any objections I'll apply this tomorrow.
Per report from EnterpriseDB's Coverity analysis.
-Neil
Index: src/inte
Bruce Momjian wrote:
Sergej, are you going to repost this patch?
Sorry for delaying.
Yes, I working on it, but I wait for decision about Andrew and Abhijit
patches.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi,
Attached patch enables dumping of LOB comments when in text mode.
I really don't get the binary/custom format LOB stuff (and don't have
time to investigate), so perhaps someone else can do that.
Having it in text format is still an improvement though.
Chris
blobcomments.txt.gz
Descript
24 matches
Mail list logo