Hello,
We have to take a backup of database and we know the pg_dump utility of postgresql.
But may I know, is there any API for this pg_dump utility so that we can call it from the C program? Or only script support is possible for this.
I think script support is bit risky because if anythin
Hello,
We are planning to use latest postgres version. I have one query as below:
One more thing I have to mention is that we are using 2 postmasters running on different machines and both are accessing same data directory. (
i.e both the machines uses same tables or the databases)
In that case
Tom Lane wrote:
An ideal solution would be to have a
"not-locale-affected-varchar" field type :)
If you're just storing ASCII then I think bytea might work for this.
Do you need any actual text operations (like concatenation), or this
just a store-and-retrieve field?
I've just tested bytea
Bloat doesn't depend on your update/delete rate; it depends on how many
update/deletes occur between vacuums. Long running transactions also
come into play.
As for performance, a P4 with 512M of ram is pretty much a toy in the
database world; it wouldn't be very hard to swamp it.
But without actu
Ivan Voras <[EMAIL PROTECTED]> writes:
> The situation is this: we're using a varchar column to store
> alphanumeric codes which are by themselves 7-bit clean. But we are
> operating under a locale which has its own special collation rules, and
> is also utf-8 encoded. Recently we've discovered
Hi all and thanks for your responses. I haven't yet had a chance to
tweak the autovac settings but I really don't think that things can be
maxing out even the default settings.
We have about 4 machines that are connected 24/7 - they were doing
constant read/inserts (24/7) but that was because the
The situation is this: we're using a varchar column to store
alphanumeric codes which are by themselves 7-bit clean. But we are
operating under a locale which has its own special collation rules, and
is also utf-8 encoded. Recently we've discovered a serious "d'oh!"-type
bug which we tracked do
On Wed, Jun 07, 2006 at 06:13:11PM +0530, soni de wrote:
> Hello,
>
>
>
> We have database on which continueous operations of INSERT, DELETE, UPDATE
> are going on, In the mean time irrespective of INSERT and UPDATE we want to
> ALTER some filelds from the table can we do that?
>
> Would the AL
Hello,
We have database on which continueous operations of INSERT, DELETE, UPDATE are going on, In the mean time irrespective of INSERT and UPDATE we want to ALTER some filelds from the table can we do that?
Would the ALTER command on heavily loaded database create any perfomance problem?
I
On Tue, 2006-06-06 at 11:41 -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > On Tue, Jun 06, 2006 at 11:06:09AM -0400, Tom Lane wrote:
> >> I don't think that helps, as it just replaces one uncertainty by
> >> another: how far did the EXPLAIN really get towards completion of
10 matches
Mail list logo
