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 actual method and met

[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-general

Re: [GENERAL] non-WAL btree?

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 rebuild on crash). Drop the index during load? Thanks

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 at once into a table that already has some

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

Re: [GENERAL] non-WAL btree?

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: It's not that I expect a lot

[GENERAL] cast affects use of indexes ?

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 subscription

[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] 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! best regards

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 Vinogradovs

[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@postgresql.org) To make

Re: [GENERAL] too many LWLocks taken

-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 ? Oh really? That's a bug, not something you need to adjust

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*

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

] = ' '; 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

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))); Should't you be using inet_in instead of textin

[GENERAL] table size in 8.3

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

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've got an application

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 starts getting those errors

[GENERAL] Concurrent modification of plpgsql function body

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

[GENERAL] copy database by copying datafiles ?

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] 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. datafiles are 85GB in size

[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 Vinogradovs

Re: [GENERAL] plpgsql trigger coredumps instance

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 triggers attached. Are there any known

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 will perform the insert into the slave

Re: [GENERAL] record-based log shipping

. 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 SQL requests. The first two issues that come

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

Re: [GENERAL] Another question about partitioning

=16480 width=0) Filter: (eid = 72333) - Seq Scan on poll_9 poll (cost=0.00..31943.33 rows=18328 width=0) Filter: (eid = 72333) On Tue, 2007-11-27 at 17:40 -0800, paul rivers wrote: Alex Vinogradovs wrote: Hello all, I have a table which is partitioned

[GENERAL] Another question about partitioning

for that, 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 ?

, 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

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

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: if posting/reading

[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

Re: [GENERAL] SPI shared memory ?

, 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 include any shared memory access, do you actually want access to postgresql's shared

[GENERAL] WAL to RAW devices ?

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

Re: [GENERAL] WAL to RAW devices ?

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 is to have say 2 raw

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

Re: [GENERAL] WAL to RAW devices ?

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, Alvaro Herrera wrote: Alex

Re: [GENERAL] WAL to RAW devices ?

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 with INSERTs only, and bunch of other guys need to obtain

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