Re: [GENERAL] C++ port of Postgres

rent HEAD? I ask because I'd like to compare your approach to the one Peter has posted, and I think that will be easier if I can use a common (or at least similar) baseline for the comparison. Kind regards, Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

Re: [GENERAL] Detecting if current transaction is modifying the database

On Mon, Aug 8, 2016 at 8:23 AM, Kevin Grittner wrote: > Your check for a exclusive self-lock on transactionid should work. > It may be possible to find a way to do it that is less expensive, > so I would definitely encapsulate that in a function; but off-hand > I'm not thinking of a better way. G

Re: [GENERAL] Detecting if current transaction is modifying the database

On Fri, Aug 5, 2016 at 1:26 PM, Rob Sargent wrote: > On 08/05/2016 02:15 PM, Christian Ohler wrote: >> >> I'm looking for a statement (or sequence of statements) that, when run >> within a transaction, tells the client if any writes are happening in >> that tran

Re: [GENERAL] Detecting if current transaction is modifying the database

On Fri, Aug 5, 2016 at 1:24 PM, Tom Lane wrote: > Christian Ohler writes: >> Thanks, fair point. I should have mentioned that I know about triggers but >> was hoping to find a less invasive mechanism (IIUC, I'd have to install a >> trigger on every table) – it seems

Re: [GENERAL] Detecting if current transaction is modifying the database

On Fri, Aug 5, 2016 at 12:55 PM, Rob Sargent wrote: > > What sort of interface are you looking for. Where/When would you grab the > information? Do what with it? Log triggers are the typical pattern here > (with packages just for that sort of thing). I'm looking for a statement (or sequence o

Re: [GENERAL] Detecting if current transaction is modifying the database

res Professional: http://www.postgrespro.com > Russian Postgres Company > > > > > On Fri, Aug 5, 2016 at 10:25 PM +0300, "Christian Ohler" > wrote: > > Hi, >> >> I'm trying to find a way to have Postgres tell me if the current >> transaction would modif

[GENERAL] Detecting if current transaction is modifying the database

r ways? Are there ways to avoid false positives due to temp tables? Thanks in advance, Christian.

Re: [GENERAL] RHEL 7

igration procedure (so I wonder why they've included it). -- *Christian Castelliskype: christrack*

Re: [GENERAL] Running query without trigger?

session_replication_role = DEFAULT; This only affects the current session i.e. you and not any other sessions which is what you seemed to require. All this assuming you run a supported version of postgres Regards, Christian Elmerot, Systems Engineer One.com -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Avoid deadlocks on alter table

lobal views so how can I update these global views without interfering with other processes? Should I avoid using these views and build by myself the queries with code? Is there another better approach for finding results with this type of architecture? Thanks. 2016-07-06 9:43 GMT+02:00 Chri

Re: [GENERAL] Avoid deadlocks on alter table

e FKs one at a time, rather > than all in one transaction. > Ok I'll try first to do this. Thanks. -- *Christian Castelliskype: christrack*

[GENERAL] Avoid deadlocks on alter table

ation 17248 is tariff_plan and 17016 is customers, both only in public schema (shared tables). I cannot understand why altering a table in a customer schema bumps into a deadlock with these two tables. Any hints how to solve this problem? Thanks. -- *Christian Castelliskype: christrack*

[GENERAL] Sequences, txids, and serial order of transactions

ortant properties that one order satisfies but the other doesn't, or that neither satisfies but that we should be aware of? (3) and (4) seem like strong reasons to go with a sequence, as long as we can live without (5) and figure out (7) and (8). Any help appreciated, Christian.

[GENERAL] Changing varchar length by manipulating pg_attribute

9.4? Also, best practice seems to be to use text nowadays, is there even a variant of this that lets me convert a "column from character varying(256)" to "text" without having to recreate all the nested views? Thanks Christian -- Sent via pgsql-general mailing list (pg

Re: [GENERAL] GIN Trigram Index Size

affraid of making the inserts slower, but I'll see if I can do a benchmark of fastupdate vs. nofastupdate and will post it here if I get to it. Thanks for your help Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] GIN Trigram Index Size

Hi Some weeks ago I got some advice here on how to build a trigram index. Now, I have implemented this in our rather large database, which looks like this: We have one table of log events per month, used as partitions via "logs": public | logs | table| postgres public |

Re: [GENERAL] How to speed up pg_trgm / gin index scan

d all the hard work you guys are putting into this. I'll follow the further development closely and report back if we get any new breakthroughs with this rather big data set. Christian -- 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] How to speed up pg_trgm / gin index scan

On 22/06/15 13:51, Christian Ramseyer wrote: > Hi > > I have a pretty large table with syslog messages. > > It is already partitioned by month, and for a single month I have e.g. > > > DM=# \d+ logs_01 > >

Re: [GENERAL] Slow index performance

You are right ... How embarrassing ... Why did I not see this? I will change the index and check again. I guess that the problem should be fixed then. Thanks a lot! Christian Deriva GmbH Financial IT and Consulting Christian Schröder

[GENERAL] Slow index performance

ull and reindexed. Can anybody explain the difference? Why is the current table so slow? And what can we do to improve performance? Thanks for your help, Christian Deriva GmbH Financial IT and Consulting Christian Schröder Gesc

Re: [GENERAL] How to speed up pg_trgm / gin index scan

I'll try to get 9.4 installed and report back with the results. Thanks Christian -- 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] How to speed up pg_trgm / gin index scan

ew installation from backup and it receives no new data at all. But it is in 9.1.15 so I try to give 9.4 a shot, as apparently I'm missing out on a lot of stuff. Christian -- 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] How to speed up pg_trgm / gin index scan

an error message etc.). It must be matched exactly including all punctuation etc, so trigrams look very suitable. Cheers Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] How to speed up pg_trgm / gin index scan

ve already tried to throw quite a bunch of memory at the problem: shared_buffers = 64GB work_mem = 16GB but it didn't improve between this and the 32GB shared/ 2GB work GB I had before. This is on Postgres 9.1.15 on Linux. Thanks Christian -- 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] unrecognized configuration parameter "bdr.connections"

Thanks IAM Regards - Christian Vazquez -- View this message in context: http://postgresql.nabble.com/unrecognized-configuration-parameter-bdr-connections-tp5843957p5844078.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing

Re: [GENERAL] multiple parameters to an AGGREGATE function

Hi, maybe this will help: CREATE OR REPLACE FUNCTION _final_nth( anyarray, integer ) RETURNS anyelement AS $BODY$ SELECT a FROM unnest( $1 ) a ORDER BY a offset $2 LIMIT 1; $BODY$ USE it without an extra aggregate-function. SELECT _final_nth(array_agg(someelement),n) AS someelement FROM so

Re: [GENERAL] indexed range queries on jsonb?

cribed here: http://www.postgresql.org/docs/9.1/static/indexes-expressional.html Christian -- 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] Upgrade to 9.3

> > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- *Christian Jensen* 2151 Burnside Road West Unit #5 Victoria, BC V9B 0P5 +1 (778) 996-4283 christ...@jensenbox.com

Re: [GENERAL] GSSAPI server side on Linux, SSPI client side on Windows

* From: Brian Crowell > On Mon, Nov 11, 2013 at 11:56 PM, Christian Ullrich > wrote: > >> On Mon, Nov 11, 2013 at 10:51 PM, Brian Crowell > wrote: > >> * If I don't specify my username, Npgsql sends it in lowercase > "bcrowell" > > > > Hm

Re: [GENERAL] GSSAPI server side on Linux, SSPI client side on Windows

know what the server wants to see. Congratulations on getting it to work. I'm a bit envious that you beat me to it (GSS auth interop between PostgreSQL on Windows and others is kind of my hobby), but the sooner, the better. -- Christian -- 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] GSSAPI server side on Linux, SSPI client side on Windows

* Christian Ullrich wrote: Nov 1 10:31:50 infra1 postgres[25277]: [7-1] FATAL: accepting GSS security context failed Nov 1 10:31:50 infra1 postgres[25277]: [7-2] DETAIL: An unsupported mechanism was requested: Unknown error Nov 1 10:39:31 infra1 postgres[25587]: [7-1] FATAL: accepting GSS

Re: [GENERAL] GSSAPI server side on Linux, SSPI client side on Windows

* Francisco Figueiredo Jr. wrote: On Tue, Nov 5, 2013 at 2:35 PM, Christian Ullrich mailto:ch...@chrullrich.net>> wrote: * Stephen Frost wrote: * Brian Crowell (br...@fluggo.com <mailto:br...@fluggo.com>) wrote: However, the eventual goal was to connect

Re: [GENERAL] GSSAPI server side on Linux, SSPI client side on Windows

* Stephen Frost wrote: * Christian Ullrich (ch...@chrullrich.net) wrote: I tried to fix it using the reverse of they one-line fix that worked in both JDBC and libpq. There, the problem was that they only supported GSSAPI and had no clue about SSPI (except libpq on Windows). The fix was to

Re: [GENERAL] GSSAPI server side on Linux, SSPI client side on Windows

re must be some difference somewhere. -- Christian -- 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] Remove or alter the default access privileges of the public schema by the database owner

med the mailing list admins that I will resend the message with a new subject and that they can safely delete the original message. Apparently, my notice got overlooked somehow. Sorry again. Christian On 15.10.2013 12:28, Christian Affolter wrote: Hi everyone I'm looking for a way to let

[GENERAL] Remove or alter the default access privileges of the public schema by the database owner

r maybe there is a complete other approach to solve this problem. Many thanks and best regards Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Alter the default access privileges of the public schema by the db owner

schema by default, or to ignore the collation settings on the template database (it will never have any data preloaded, only the ownership of the public schema changed)? Or maybe there is a complete other approach to solve this problem. Many thanks and best regards Christian --

Re: [GENERAL] custom session variables?

tly the same, which seem to be your goal. bye, -christian- Am Wed, 24 Apr 2013 16:17:58 -0700 schrieb Darren Duncan : > Hello, > > I would like to have one or more session-scoped global variables that > are useable in a similar way to sequence generators, via analogies to >

Re: [GENERAL] Queries seldomly take >4s while normally take <1ms?

On Tue, 9 Apr 2013 07:25:16 -0700 (PDT) Kevin Grittner wrote: > Christian Hammers wrote: > > > 9.2.3 > > You really need to think about 9.2.4 Real Soon Now; there's a > security fix that you probably should not wait on. Is scheduled (no access from outside to tha

Re: [GENERAL] Queries seldomly take >4s while normally take <1ms?

Hello On Tue, 9 Apr 2013 03:53:13 -0700 (PDT) Greg Williamson wrote: > Christian -- > > > > postgres version ? 9.2.3 > type of replication ? As written, one master does streaming replication to two slaves. > changes from postgres config defaults ? m

[GENERAL] Queries seldomly take >4s while normally take <1ms?

rs :-) The queries contain obvious customer data so I'm reluctant to give examples but again I doubt that an explain plan will help if only 1 out of 4E6 queries takes too long. bye, -christian- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscript

[GENERAL] Difference between Python and Postgres locale currency formats

UTF-8') locale.currency(1.234) # '1,23 $' while using Postgres 9.1: set lc_monetary = 'fr_CA.UTF-8'; select 1.234::money; -- '$1,23' I think the Python version is the right one (not 100% sure though), but how can they possibly be different? Thanks, Christian -- Sent via p

Re: [GENERAL] PostgreSQL connect with Visual C++

directory. As an alternative, you can just add that directory to your %PATH% variable. -- Christian -- 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] Perl function leading to out of memory error

NSERT INTO foo (isin) VALUES (isin); END; $$ LANGUAGE plpgsql VOLATILE STRICT; This works without any problem. Regards, Christian -- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consulting Fax: +49 551 489500-91 Hans-Böckler-Straße 2 http://www.

Re: [GENERAL] Perl function leading to out of memory error

t of memory error occurs. Interestingly, if we change the type specification in the call to "spi_prepare" from "isin" to "char(12)" the problem no longer occurs. Can you explain this behavior? Regards, Christian -- Deriva GmbH Tel.: +49 551 48

Re: [GENERAL] rights for schema

quot;), put all your users in it and grant permissions to that role. Remember, though, that newly created users have to be explicitly added to that group by the admin and new tables have to be given access to that role by the admin or the creating user! bye, -christian- -- Sent via pgsql-general ma

Re: [GENERAL] update from a csv file?

ll want to COPY FROM on a new table that has the same structure: > > BEGIN; > CREATE TEMPORARY TABLE original_table_name_temp( LIKE original_table_name > INCLUDING ALL ); > COPY original_table_name_temp FROM stdin; The "INCLUDING ALL" will also generate the same unique key

Re: [GENERAL] Composite Indexes with a function and a column

or crash by doing an ORDER BY which uses an index that returns random values...) bye, -christian- On Fri, 21 Dec 2012 10:31:43 -0200 Alex Pires de Camargo wrote: > Thanks a lot! > > From documentation: > > " > IMMUTABLE indicates that the function cannot modify the da

Re: [GENERAL] Composite Indexes with a function and a column

Hello On Fri, 21 Dec 2012 08:46:14 -0200 Alex Pires de Camargo wrote: > Is it possible? > >Thanks! Why not? devel_np=# CREATE TABLE t (i int); CREATE TABLE devel_np=# CREATE INDEX ON t (length(i::text), i); CREATE INDEX bye, -christian- -- Sent via pgsql-general mai

Re: [GENERAL] Monitoring streaming replication from standby on Windows

sfully waits for WAL files which were long deleted on the master, this line changed to "startup process waiting". HTH, -christian- On Fri, 14 Dec 2012 09:52:49 -0400 Yamen LA wrote: > > Thank you Karl. > > I am trying to determine on the slave itself whether streaming

[GENERAL] logcheck compatible daily logfile rotation?

that I modify the /etc/init.d/ script which would work but I hate editing Debian package scritps because such modifications are too easily broken on updates. At the moment I'm stuck with syslog and a custom rsyslog template but still, I'm curious what others are doing! bye, -christian- --

Re: [GENERAL] Correlation in pg_stats

e) SELECT random() FROM generate_series(1, 100); bye, -christian- Am Mon, 26 Nov 2012 01:52:21 -0800 (PST) schrieb classical_89 : > Hi,First sorry for my bad English :D.I'm new in PostgreSQL and > database .Now i'm researching about statistic correlation .I want to > make a

[GENERAL] How and for what to use SP-GIST?

uot;LIKE '%foo'". I'm interested because I heavily use the prefix_range extension for phone number searching. Could I somehow benefit from a SP-GIST suffix index (maybe by reversing my numbers)? thanks for any comments! bye, -christian- -- Sent via pgsql-gene

Re: [GENERAL] 9.1 to 9.2 requires a dump/reload?

Hello Can you remember where did you read that? There is no mention of GIST on http://www.postgresql.org/docs/9.2/static/upgrading.html and a database which uses GIST indexes *seems* to work just finde after upgrading with pg_upgrade. bye, -christian- Am Mon, 22 Oct 2012 15:02:13 -0700

[GENERAL] Full text search in Chinese

deal on so I really rather not go out to Solr or anything external if possible. I bet there is something simple as it seems like each character is an individual search term. Thoughts? Hints? Am I posting in the right place? Thanks! -- *Christian Jensen* 724 Ioco Rd Port Moody, BC V3H 2W8 +1 (

[GENERAL] When do archived WAL files gets removed after wal_keep_segments changed?

ivedir/%f && cp %p /srv/postgresql-archivedir/%f' wal_keep_segments = 500 hot_standby = on bye, -christian- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Why is the wrong index used? (with "gist" index)

| extended | [...] Indexes: "destinations_pkey" PRIMARY KEY, btree (id) "destinations_nr_unique_idx" UNIQUE, btree (nr) "destinations_nr_gist_idx" gist (nr) "destinations_nr_length_idx" btree (length(nr)) "destinatio

Re: [GENERAL] FATAL : could not read directory base": Invalid argument

quot; , so add the opening quote back. -- Christian -- 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] I cannot insert bengali character in UTF8

ird byte is a single character, a period ("."), to be exact. Setting the MSB on the third byte gives us 1110 10100110 10101110 = E0 A6 AE , which is a valid UTF-8 encoding of U+09AE BENGALI LETTER MA. Check your input data. -- Christian -- Sent via pgsql-general mail

[GENERAL] missing pg_clog files after pg_upgrade

because I could not restore missing pg_clog files. What can I do? Thanks in advance, Chris [1]: http://wiki.postgresql.org/wiki/20110408pg_upgrade_fix -- Christian J. Dietrich Institute for Internet Security - if(is) Westfaelische Hochschule University of Applied Sciences https://www.in

[GENERAL] Problems with restoring data (using pg_restore)

m could be related to the "-n" option. Could someone guide me in the right direction on how to solve this problem? Thanks Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Problems with restoring data (using pg_restore)

m could be related to the "-n" option. Could someone guide me in the right direction on how to solve this problem? Thanks Christian -- 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] Audtiting, DDL and DML in same SQL Function

On 2/2/12 12:39 AM, Scott Marlowe wrote: > On Wed, Feb 1, 2012 at 4:27 PM, Scott Marlowe wrote: >> On Wed, Feb 1, 2012 at 3:29 PM, Christian Ramseyer wrote: >>> Optimally, I'd just have my applications perform a single >>> call after connecting, e.g. "audit_

[GENERAL] Audtiting, DDL and DML in same SQL Function

reate, it works fine. So apparently the objects in the DML must be available at parse time of the function body. Is there an easy way around this? Optimally, I'd just have my applications perform a single call after connecting, e.g. "audit_init('USERNAME', 'Name of

Re: [GENERAL] Cisco Systems fail

://petereisentraut.blogspot.com/2008/03/readding-implicit-casts-in-postgresql.html> Good luck Christian -- Christian Ramseyer r...@networkz.ch -- 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] Postgresql Data directory Issue

reconfigure before starting the database. -- Christian -- 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] Would it be possible

* Adarsh Sharma wrote: I have following files in my pg_xlog directory : 000100070091 [...] 000100070098 I think I issued the drop database command 1 month ago. From the manual, I understand that my segment files are recycled to newer ones : PostgreSQL always writes

Re: [GENERAL] Would it be possible

nder "Point In Time Recovery" (PITR). -- Christian -- 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] Dump large DB and restore it after all.

end the whole dump to psql at once, not piece by piece. Instead of psql dbname < filename.1 psql dbname < filename.2 do this: cat filename.1 filename.2 | psql dbname -- Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To mak

Re: [GENERAL] Location Data

* Adarsh Sharma wrote: Christian Ullrich wrote: Write a set of functions to get the higher-level structures (country for states, etc.) for any given record, and put a trigger on the table that populates the fields on insert and update. All the world data is populated in the places

Re: [GENERAL] Location Data

ate. Sort of a materialized view. If you have little query activity on the table, create a view that calls the functions. -- Christian -- 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] PostgreSQL and XA Distributed Transaction Protocol

omething has changed in the meantime? (Have PostgreSQL yet implemented the standard native C XA library?).   Any hints will be appreciated.   Thank you so much Regards Christian

Re: [GENERAL] Drop CHECK Constraint

table from the catalog: SELECT conname FROM pg_constraint WHERE conrelid = 'backup_table'::regclass You may have to add more conditions to the query. -- Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscrip

Re: [GENERAL] Multithreaded query onto 4 postgresql instances

nning multiple queries in parallel, especially if you can limit I/O and lock contention by matching queries to partitions. -- Christian -- 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] Using copy for WAL archiving on Windows

return ((argc == 3 && CopyFile(argv[1], argv[2], TRUE) != 0) ? 0 : 1); } ### end ### archive_command = "archive_wal %p c:\wal\%f" -- Christian -- 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] PostgreSQL 9.0.1 PITR can not copy WAL file

TR/WAL/%f' It works with the forward slashes if the destination path is quoted, but it looks like you did not do that in any of your examples. Other than that, I have no idea. -- Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to you

Re: [GENERAL] PostgreSQL 9.0.1 PITR can not copy WAL file

events from cmd.exe for the ten seconds following that timestamp. If it is overly much, please send it to me directly. -- Christian -- 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] PostgreSQL 9.0.1 PITR can not copy WAL file

* tuanhoanganh wrote: I download postgresql from Enterprise DB On Thu, Jan 20, 2011 at 6:06 AM, Christian Ullrich mailto:ch...@chrullrich.net>> wrote: We cannot assume that the one-click installer was used, but if it was, the service account it creates will be a member of the

Re: [GENERAL] PostgreSQL 9.0.1 PITR can not copy WAL file

* Magnus Hagander wrote: On Wed, Jan 19, 2011 at 19:20, Christian Ullrich wrote: So when PostgreSQL runs "copy 000...5E D:\...", it fails, and when you do the same thing as the PostgreSQL user, it works. Interesting. Try increasing the log level in postgresql.conf to see if i

[GENERAL] Using copy for WAL archiving on Windows

change. Now two servers archive to the same shared directory, and neither notices. Should PostgreSQL maybe provide its own file-copy utility for Windows that meets the requirements for safe WAL archiving? -- Christian -- 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] PostgreSQL 9.0.1 PITR can not copy WAL file

Make sure the PostgreSQL data directory and the backup directory are excluded. Run procmon <http://technet.microsoft.com/en-us/sysinternals/bb896645> to see what copy tries to do when it fails. -- Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] PostgreSQL 9.0.1 PITR can not copy WAL file

n copy the file yourself, you have a permissions problem. Make sure the PostgreSQL service user has full control on both the source and target directories. -- Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www

Re: [GENERAL] Optimal settings for embedded system running PostgreSQL

> > Von: pgsql-general-ow...@postgresql.org im Auftrag von Ivan Voras > Gesendet: Do 13.01.2011 15:47 > An: pgsql-general@postgresql.org > Betreff: Re: [GENERAL] Optimal settings for embedded system running > PostgreSQL > > On 13/01/2011

[GENERAL] Optimal settings for embedded system running PostgreSQL

this forum. Thanks for any help, Christian -- +--+---+ Embedded Solutions | DI Christian Walter Lorenz Böhler Gasse 4/4, A-1200 Wien | cwal...@embedded-solutions.at http://www.embedded-solutions.at

Re: [GENERAL] How to search ignoring spaces and minus signs

7; ','') = '12344'; prod_code | replace ---+- 12 3-44 | 12344 12-3-44 | 12344 123 44| 12344 Or just store the codes in a uniform format to begin with. Christian -- 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] Group By Question

= l.ref AND l.date = l.maxdate); On this "dataset", the windowed version is estimated to be ~ 60% faster than the grouped one, and the actual execution time is ~ 20% lower. -- Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your su

Re: [GENERAL] PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install

ion because it cannot read the contents of its target directory. -- Christian -- 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] libpq (C++) - Insert binary data

upports any changes in future versions, you should consider using the "hex" text format instead. See section 8.4.1 of the manual for version 9.0. -- Christian -- 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] FTS GIN Index Question

On 09/29/2010 12:10 PM, Oleg Bartunov wrote: Christian, On Wed, 29 Sep 2010, Christian Ramseyer wrote: Hi List I have a largish partitioned table, it has ~60 million records in each of 12 partitions. It appears that a Full Text Index could speed up some user queries a lot. A quick test with

[GENERAL] FTS GIN Index Question

garding full text search configurations of that size are very welcome. Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] pgp encryption functions

gW32) lQO+BErk2KkBC... (private key block) ... -END PGP PRIVATE KEY BLOCK- '), 'ktulu3437') --> this is the passphrase FROM "Test"; Encryptions works fine, but the decrypting returns "Corrupt data". What am I doing wrong? Christian Petzold. -- Sent

[GENERAL] Wrong estimation of rows for hash join

ve the speed of the hash join itself? I understand that 2.5 secs are needed to perform the sequential scan of table b, but where do the remaining 2.5 secs come from? Thanks a lot in advance, Christian -- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consult

[GENERAL] Storage of Foreign Keys

thing like a pointer/reference from mycolA to the things stored in mycolB? Thanks alot for any information, Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] PostgreSQL and XA Distributed Transaction Protocol

Hi all, I'm developing a new, free, XA compliant transaction manager. One of the first resource manager I would be glad to support is PostgreSQL; after some googling I have found no information related to PostgreSQL and XA protocol support. Can anyone give me more information related to this matt

Re: [GENERAL] Performance of full outer join in 8.3

Tom Lane wrote: I've applied a patch for this. It will be in 8.3.8, or if you're in a hurry you can grab it from our CVS server or here: Thanks a lot for your effort and the quick response! Regards, Christian -- Deriva GmbH Tel.: +49 551 489500-42 Fi

Re: [GENERAL] Performance of full outer join in 8.3

index was available and usable. hance my question, if there's index on it in 8.3 version of db. I added an index on this column, but it didn't change the query plan. Stupid question: Do I have to analyze again or perform a reindex after adding the index? Regards, Christian

Re: [GENERAL] Performance of full outer join in 8.3

x27;t this matter in 8.2?? Regards, Christian -- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consulting Fax: +49 551 489500-91 Hans-Böckler-Straße 2 http://www.deriva.de D-37079 Göttingen Deriva CA Certificate: http://www.deriva

[GENERAL] Performance of full outer join in 8.3

Type | Modifiers +-+--- attachment | integer | not null isin | isin| not null Indexes: "rec_isin_pkey" PRIMARY KEY, btree (isin, attachment) "idx_rec_isins_attachment" btree (attachment) Foreign-key constraints: "rec_isins_a

Re: [GENERAL] Performance of subselects

abase administration (including performance tuning) and application development. Is this idea completely wrong? Regards, Christian -- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consulting Fax: +49 551 489500-91 Hans-Böckler-Straße 2

Re: [GENERAL] Performance of subselects

how much memory they consume? This would help to find out if the value can be changed without running out of memory. Regards, Christian Schröder -- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consulting Fax: +49 551 489500-91 Hans-Böckler-Straße 2

  1   2   3   4   >