Re: [GENERAL] plpgsql returning resultset

I believe you need to use for execute '...' loop, since the table_name is dynamically composed. Regards, Alex Vinogradovs On Tue, 2008-09-02 at 23:19 +0200, Thomas Finneid wrote: > Hi again, I tried to take the "with" form of the function further to > complete the

Re: [GENERAL] non-WAL btree?

't have to run reindex at all ;) Btw, SELECT INTO is also a non-WAL operation when archiving is disabled, or am I missing something ? Alex. On Fri, 2008-08-01 at 16:43 -0500, Jaime Casanova wrote: > On Fri, Aug 1, 2008 at 3:36 PM, Alex Vinogradovs > <[EMAIL PROTECTED]> wrote: &

Re: [GENERAL] non-WAL btree?

It's not that I expect a lot of improvement by having non-WAL indexing, it just sounds logical to me to have that, since index can be re-created fast enough during recovery, and it would reduce my IO to some extent. Alex. > Sorry, as I hit send, I realized I should clarify this: I do my bulk > lo

Re: [GENERAL] non-WAL btree?

Isn't hash indexing implementation non-WAL ? Alex. On Fri, 2008-08-01 at 13:16 -0700, Joshua Drake wrote: > On Fri, 01 Aug 2008 13:07:18 -0700 > Alex Vinogradovs <[EMAIL PROTECTED]> wrote: > > > By loading in bulks, I mean I load some 40-50 thousand > > rows a

Re: [GENERAL] non-WAL btree?

700 > Alex Vinogradovs <[EMAIL PROTECTED]> wrote: > > > Guys, > > > > I was wondering if there is a btree indexing implementation that > > is not WAL-logged. I'm loading data in bulks, and index logging > > is an unnecessary overhead for me (easier to

[GENERAL] non-WAL btree?

Guys, I was wondering if there is a btree indexing implementation that is not WAL-logged. I'm loading data in bulks, and index logging is an unnecessary overhead for me (easier to rebuild on crash). Thanks! best regards, Alex Vinogradovs -- Sent via pgsql-general mailing list (pgsql-ge

[GENERAL] cast affects use of indexes ?

where column = 89464::mytype; bitmap index scan and bitmap heap scan are used. Is it possible to make it work properly without use of explicit casts ? Thanks! Best regards, Alex Vinogradovs -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscri

Re: [GENERAL] xlogdump & pgview

Okay, looks like pgdview 0.2 was released just yesterday, and it supports 8.3 ;) On Tue, 2008-05-06 at 14:20 -0700, Alex Vinogradovs wrote: > Guys, > > Are there low-level maintenance tools, such as xlogdump and pgview, > available for version 8.3 datafiles/wal logs ? Thanks!

[GENERAL] xlogdump & pgview

Guys, Are there low-level maintenance tools, such as xlogdump and pgview, available for version 8.3 datafiles/wal logs ? Thanks! best regards, Alex Vinogradovs -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] too many LWLocks taken

It appears the errors were caused by table corruption. I've truncated and reloaded some large table (300m entries), and the problem disappeared. Table corruption was probably caused by hardware failure, not by PostgreSQL :) On Fri, 2008-04-04 at 20:15 -0400, Tom Lane wrote: > Alex Vin

Re: [GENERAL] too many LWLocks taken

18:58 -0400, Tom Lane wrote: > Alex Vinogradovs <[EMAIL PROTECTED]> writes: > > I've got a pretty large database, and since certain time > > it started giving me "too many LWLocks taken" when running > > some batch inserts... Any parameter can be ajusted ? &

[GENERAL] too many LWLocks taken

Guys, I've got a pretty large database, and since certain time it started giving me "too many LWLocks taken" when running some batch inserts... Any parameter can be ajusted ? Thanks! Best regards, Alex Vinogradovs -- Sent via pgsql-general mailing list (pgsql-general@postgres

Re: [GENERAL] IBM investing in EnterpriseDB

Shouldn't forget IBM got DB2. Could be they are just seeking additional userbase in opensource market space... On Wed, 2008-03-26 at 12:12 -0700, Ron Mayer wrote: > Clodoaldo wrote: > > ...IBM is investing...What does it mean for Postgresql? > > One cool thing it means is that there are now *two

Re: [GENERAL] SPI_execute_plan(): how to make a Datum to insert type inet ?

That solved my problem. Thanks! On Wed, 2008-03-19 at 21:13 +0200, Volkan YAZICI wrote: > On Wed, 19 Mar 2008, Alex Vinogradovs <[EMAIL PROTECTED]> writes: > > params[0] = DirectFunctionCall1(textin, > > CStringGetDatum(pstrdup("192.168.1.1"))); > > Sho

[GENERAL] SPI_execute_plan(): how to make a Datum to insert type inet ?

"192.168.1.1"))); nulls[0] = ' '; if(SPI_execute_plan(plan, params, nulls, FALSE, 1) <= 0) { // handle the error } Thanks! Best regards Alex Vinogradovs -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] table size in 8.3

.3. Best regards, Alex Vinogradovs -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Concurrent modification of plpgsql function body

Yes, I'm using CREATE OR REPLACE. Alex. On Mon, 2008-01-07 at 16:17 -0300, Alvaro Herrera wrote: > Alex Vinogradovs wrote: > > I mean I re-create the function with the same signature but > > different body, and when the application invokes that function > > again, it s

Re: [GENERAL] Concurrent modification of plpgsql function body

I mean I re-create the function with the same signature but different body, and when the application invokes that function again, it starts getting those errors. Alex. On Fri, 2008-01-04 at 15:36 -0500, Tom Lane wrote: > Alex Vinogradovs <[EMAIL PROTECTED]> writes: > > I'v

[GENERAL] Concurrent modification of plpgsql function body

node type: 1852387187 Is it allowed to modify those functions from other connections ? Thanks! Best regards, Alex Vinogradovs ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] copy database by copying datafiles ?

Sorry guys, was my mistake... I found one file missing in global tablespace. Copying it there fixed the problem. Thanks everyone! On Mon, 2007-12-24 at 14:07 -0800, Richard Broersma Jr wrote: > --- On Mon, 12/24/07, Alex Vinogradovs <[EMAIL PROTECTED]> wrote: > > > P.S. dat

[GENERAL] copy database by copying datafiles ?

n size, I couldn't really dump and restore... Thank you! Best regards, Alex Vinogradovs ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] plpgsql trigger coredumps instance

6.2 AMD64 running on Xeon 64 bit. On Thu, 2007-12-13 at 20:08 -0500, Tom Lane wrote: > Alex Vinogradovs <[EMAIL PROTECTED]> writes: > > I've got a strange situation where instance may crash sometimes on > > pgplsql function call that performs several inserts into tables with

[GENERAL] plpgsql trigger coredumps instance

Guys, I've got a strange situation where instance may crash sometimes on pgplsql function call that performs several inserts into tables with triggers attached. Are there any known bugs regarding plpgsql and triggers in 8.2.5 ? Thanks! Best regards, Alex Vinogr

Re: [GENERAL] record-based log shipping

BMS'es). Alex. On Sat, 2007-12-08 at 01:10 -0500, Greg Smith wrote: > On Fri, 7 Dec 2007, Alex Vinogradovs wrote: > > > The documents highlights possible problems with _SQL_ query intercepts. > > I am talking about the actual tuples... i.e. row data rather than the > >

Re: [GENERAL] record-based log shipping

: > On Fri, 7 Dec 2007, Alex Vinogradovs wrote: > > > How about writing a C function (invoked from a trigger) that will send > > the serialized tuple using say UDP protocol (considering you're syncing > > on a reliable LAN), and then a simple UDP-listening daemon that wil

Re: [GENERAL] record-based log shipping

How about writing a C function (invoked from a trigger) that will send the serialized tuple using say UDP protocol (considering you're syncing on a reliable LAN), and then a simple UDP-listening daemon that will perform the insert into the slave one. If you have multiple slaves, can use that with b

Re: [GENERAL] Another question about partitioning

ote: > Alex Vinogradovs wrote: > > Hello all, > > > > > > I have a table which is partitioned by range into 10 pieces with > > constraint exceptions. Constraint exceptions is enabled in server > > configuration too. For some reason, queries to the master table > &

[GENERAL] Another question about partitioning

, or I should look into misconfiguration ? Thanks! Best regards, Alex Vinogradovs ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] Rules slower than Dynamic SQL ?

st regards, Alex Vinogradovs ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] PG_TRY(), PG_CATCH()....

No, I'm not worried about them failing. My code isn't transactional... I'm just worried about getting whole bunch of warnings about reference leaks. On Tue, 2007-10-09 at 09:59 -0400, Alvaro Herrera wrote: > The only code that knows how to cleanup completely after transaction > failure is the su

[GENERAL] PG_TRY(), PG_CATCH()....

ome proper cleanup mechanisms, but I was wondering if it is possible to bypass that layer, and make the code above work fine just by doing some cleanup within the catch block. Thanks! Best regards, Alex Vinogradovs ---(end of broadcast)--- TIP 1:

Re: [GENERAL] SPI shared memory ?

50 -0700, Alex Vinogradovs wrote: > > Guys, > > > > > > Is there any exposed PG-specific API to utilize shared memory while > > working with SPI ? Thanks! > > > > What are you trying to do? > > The available SPI functions don't inclu

[GENERAL] SPI shared memory ?

Guys, Is there any exposed PG-specific API to utilize shared memory while working with SPI ? Thanks! Best regards, Alex Vinogradovs ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an

Re: [GENERAL] WAL to RAW devices ?

Yeah, that's the trick... I need high availability with high performance and nearly real-time synchronization ;-) Also, I've got FreeBSD here... ZFS will be out with 7.0 release, plus UFS2 has snapshotting capability too. But the whole method isn't good enough anyway. > Oh, I see. > > What I've

Re: [GENERAL] WAL to RAW devices ?

Drake wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Alex Vinogradovs wrote: > > Hi guys, > > > > > > I've got a bunch of PosgreSQL servers connected to external storage, > > where a single server needs to be serving as WO database dealing

Re: [GENERAL] WAL to RAW devices ?

ither, since PG will be writing to that location. The only way is to do the WAL shipping, which probably wouldn't be that bad since the copying would be done via DMA, but still isn't as good as it could be since that would utilize the same spindles... On Fri, 2007-08-31 at 20:23 -0400, Alv

Re: [GENERAL] WAL to RAW devices ?

But would it be a problem to have only 1 active segment at all times ? My inspiration pretty much comes from Oracle, where redo logs are pre-configured and can be switched by a command issued to the instance. > Just because you'd like that to be true doesn't make it true. We have > to manage a v

Re: [GENERAL] WAL to RAW devices ?

vable tablespaces, raw devices for tablespaces, etc), thus I foresee the model described as the only way to achieve somewhat decent performance in a stressed environment. On Fri, 2007-08-31 at 19:21 -0400, Tom Lane wrote: > Alex Vinogradovs <[EMAIL PROTECTED]> writes: > > The idea

[GENERAL] WAL to RAW devices ?

aybe with minor modifications ? Thanks! Best regards, Alex Vinogradovs ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/