[GENERAL] Can I integrate PostgreSQL into MS Visual Studio EXPRESS ?

You can try to use this latest PostgreSQL ODBC driver with VS Express. Here is the driver https://www.devart.com/odbc/postgresql/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Troubles with Postgresql performance

Hello. I had a strange issue with postgresql 9.3 server. Load on server rapidly increased, queries which took about 4ms were executed for 100ms and creation a foreign key on empty table blocked all queries to server. After server restart everithing became fine again, the same foreign key was create

[GENERAL] Query plan different depending on the value of where filter

ALYZE the tables the original query will run in a few ms instead of 15 seconds, it actually uses the same query plan that swapping the tables creates. So it runs the index scan on inner_tab_1 first. It's a bit surprising that with ANALYSE it picks a plan that is so much worse. Any one able

Re: [GENERAL] Using POSIX Regular Expressions on xml type fields gives inconsistent results

On 12/21/2012 10:35 AM, David Johnston wrote: If you look at the four examples which follow the posix match table in the docs (http://www.postgresql.org/docs/9.1/static/functions- matching.html#FUNCTIONS-POSIX-TABLE), some of them work from the left side, e.g.: 'abc' ~ '(b|d)' true In my orig

Re: [GENERAL] Using POSIX Regular Expressions on xml type fields gives inconsistent results

Hi David, On 12/20/2012 08:48 PM, David Johnston wrote: -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- ow...@postgresql.org] On Behalf Of Denis Papathanasiou Sent: Thursday, December 20, 2012 7:56 PM To: pgsql-general@postgresql.org Subject: [GENERAL

[GENERAL] Using POSIX Regular Expressions on xml type fields gives inconsistent results

I have a table with an xml type column, and while I can make regex queries like this successfully: => select id from form_d where 'kumar' ~* any( CAST(xpath('//PersonsList/PersonName/LastName/text()', data) as TEXT[]) ); id -- 97e1541b-27f

[GENERAL] Question about data corruption issue of 9.1 (pre 9.1.6)

in advance Denis Gasparin --- Edistar SRL

[GENERAL] Temporal database design with a twist (hard question)

I'm looking into implementing object-versioning with the added twist of needing to have both live and draft objects, and could use the insights from someone experience in this, as I'm beginning to wonder if it's even possible without potentially horrific hacks. I'll break it down to posts with

[GENERAL] Make problems / 3rd-party extension w/ PostgreSQL 9.1 on MacOSX

cally when running sudo make [command] from the shell. Might any Mac-user on the list know how to do that? Thanks in advance! Denis -- 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] Differences between to_tsquery() and plainto_tsquery() when it comes to applying an index?

That index doesn't match the query, so it can't be used. Try select item_pk from node where tag='primaryIssuer.entityType' and to_tsvector('english', val) @@ plainto_tsquery('Limited Partnership'); Tom and Oleg: thank you for clarifying this. I see where I made the mistake in applying the e

Re: [GENERAL] Differences between to_tsquery() and plainto_tsquery() when it comes to applying an index?

we need examples of your explain analyze. I don't want to waste my time reading theoretical reasoning :) Here's an actual 'explain analyze' example: alerts=> CREATE INDEX node_val_tsv_idx ON node USING gin(to_tsvector('english', val)); CREATE INDEX alerts=> explain analyze select item_pk fr

Re: [GENERAL] Differences between to_tsquery() and plainto_tsquery() when it comes to applying an index?

Not per se, but maybe looking at the actual outputs of the two function calls would be enlightening. I suspect you'll find that the search conditions you are getting are not equivalent. Strictly speaking they're not, b/c the plainto_tsquery() is chaining several tokens together. However, a

[GENERAL] Differences between to_tsquery() and plainto_tsquery() when it comes to applying an index?

As a follow-up to my question from this past Saturday (http://archives.postgresql.org/pgsql-general/2010-08/msg00624.php), I experimented with adding two types of indices to the same text column: CREATE INDEX item_eng_searchable_text_idx ON item USING gin(to_tsvector('english', searchable_text));

Re: [GENERAL] Feature proposal

nging any line of data or code in sql ! Incredible, isn't it ? Denis -- 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] recovery fail

Same version of postgresql (backup and restore) ? If not, some small adaptations are always necessary... What do you get as errors or warnings ? Denis -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Optimal indexing of Full Text Search (ts_vector & ts_query) columns?

After reading the documentation on Full Text Search here http://www.postgresql.org/docs/8.4/interactive/textsearch-tables.html I created the following table and index: CREATE TABLE item ( pk uuid primary key, ... [more columns here] ... searchable_text text not null ); CREATE INDEX ite

[GENERAL] Optimal indexing of Full Text Search (ts_vector & ts_query) columns?

After reading the documentation on Full Text Search here http://www.postgresql.org/docs/8.4/interactive/textsearch-tables.html I created the following table and index: CREATE TABLE item ( pk uuid primary key, ... [more columns here] ... searchable_text text not null ); CREATE INDEX item_

[GENERAL] Unable to stop postgresql ("failed") -> [SOLVED]

y solution that worked in that case was : * /usr/bin/pg_ctl stop Have a nice day ! Denis -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Odd behaviour in update rule

urned value=3) but this is not the case... Is it the correct behaviour? Thank you, Denis

Re: [GENERAL] Strange "bug" in dump ?

reat, then it's not a bug but "String Constants with C-Style Escapes" ! But this seems to be a 8.4 feature not supported by 7.4.6 ? If you have an idea on how to have 7.4.6 accept it... Thanks a lot for your help :-) Denis -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Strange "bug" in dump ?

fails, and there is a very strange error ! There is a "E" before the street field ! This is an extract of the dump : 'ST311PHANIE ROBERT', NULL, E'RTE DES TATTES D\\''OIE 5', 311 is shown instead of accent Does someone knows what could be this problem ? D

Re: [GENERAL] [PERFORM] Strange performance degradation

Bouncing the app will roll back the transactions. If there were any pending updates/inserts, wouldn't he be able to see them in one of the system tables... On 11/24/09, Matthew Wakeling wrote: > On Tue, 24 Nov 2009, Denis Lussier wrote: >> IMHO the client application is alread

Re: [GENERAL] [PERFORM] Strange performance degradation

IMHO the client application is already confused and it's in Prod. Shouldn't he perhaps terminate/abort the IDLE connections in Prod and work on correcting the problem so it doesn't occur in Dev/Test?? On 11/24/09, Matthew Wakeling wrote: > On Mon, 23 Nov 2009, Lorenzo Allegrucci wrote: >> Anyway

Re: [GENERAL] Invalid Page Header Error

ould never > trust the data without comparing it to a backup. > > So - make sure your last backup restores OK. Check your hardware works. > Make sure you have fsync turned on and your disks are syncing when they > say they do. Yes finally we started back from the last backup (a script

Re: [GENERAL] What order of steps of the postgres when you change information in the table?

On Fri, 30 Oct 2009 23:29:49 -0600 Scott Marlowe wrote: > 2009/10/30 Denis Feklushkin : > > > > Problem: > > It is necessary to synchronize the "users" table with an > > external storage of passwords (krb5) > > > > I made a trigger: > > >

[GENERAL] What order of steps of the postgres when you change information in the table?

Problem: It is necessary to synchronize the "users" table with an external storage of passwords (krb5) I made a trigger: CREATE TRIGGER "10_krb5" AFTER INSERT OR UPDATE OR DELETE ON users FOR EACH ROW EXECUTE PROCEDURE user2krb5_python(); Everything works, except that when you d

[GENERAL] Invalid Page Header Error

how postgres can clean himself again... Thanks a lot for any advice... Denis -- 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 GRANT rights to modify a table ???

Denis BUCHER a écrit : > Tom Lane a écrit : >> "Raymond O'Donnell" writes: >>> On 12/09/2009 16:44, Denis BUCHER wrote: >>>> ERROR: must be the owner of the mytable relation >>> The clue is in the error message :-) GRANTing ALL doesn&#x

Re: [GENERAL] How to GRANT rights to modify a table ???

Hello, Tom Lane a écrit : > "Raymond O'Donnell" writes: >> On 12/09/2009 16:44, Denis BUCHER wrote: >>> ERROR: must be the owner of the mytable relation > >> The clue is in the error message :-) GRANTing ALL doesn't make them >> the own

Re: [GENERAL] How to GRANT rights to modify a table ???

mytable_owner; > GRANT mytable_owner TO myself, mycolleague, ... ; > > I highly recommend reading the GRANT command reference page. > > regards, tom lane That's great, in fact this is the right solution, I didn't think about it... Thanks a lot... Den

[GENERAL] How to GRANT rights to modify a table ???

: ALTER TABLE mytable ADD COLUMN field integer; ERROR: must be the owner of the mytable relation Therefore, how to give right to some user on tables structure ??? Thanks a lot for any help, this problem is always giving us lots of difficulties... Denis -- Sent via pgsql-general mailing list

Re: [GENERAL] Strange "missing tables" problem

Tom Lane a écrit : > Denis BUCHER writes: >> Yes that's correct. Therefore my "problem" is the "normal" behavior of >> \dt. But "normal" means "expected". But I don't find it very >> secure/handy, because you expect to see a

Re: [GENERAL] Strange "missing tables" problem

h_path configuration. > > I suppose you have something like 'rma, import, ...' for search_path, so it > only displays rma.customers and not impor.customers. Yes that's correct. Therefore my "problem" is the "normal" behavior of \dt. But "norm

Re: [GENERAL] Strange "missing tables" problem

Hello Tom, Tom Lane a écrit : > Denis BUCHER writes: >> I really don't understand what's happening here ? > > "\dt customers" will show you the customers table that's visible > according to your search_path setting. Apparently schema "import

Re: [GENERAL] Strange "missing tables" problem

Hello, > # VACUUM pg_catalog.pg_class; > VACUUM > # VACUUM pg_catalog.pg_tables; > ATTENTION: ignore « pg_tables » --- could not execute VACUUM on indexes, > views or system tables > VACUUM Denis Bill Bartlett a écrit : > Possible xid rollover problem? (We saw beh

Re: [GENERAL] Strange "missing tables" problem

gt;> rma | customers | table | postgres >> (2 lignes) >> >> > you have two tables 'customers', one in schema 'import', the other one > in schema 'rma' Yes that's correct > I assume you want to keep two copies of this table, right? Yes, in fact they are two different tables... Denis -- 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] Strange "missing tables" problem

taire -+-+---+-- import | customers | table | postgres rma | customers | table | postgres (2 lignes) I really don't understand what's happening here ? Denis > That's what I found, do you see something inside that looks interesting ? > > # SELECT * FROM pg_c

Re: [GENERAL] Strange "missing tables" problem

| hasrules | hastriggers -+---++++--+- bw_import_as400 | clients | postgres || f | f | f rma | clients | postgres || t | f | f (2 lignes) Thanks a lot for your help :-) Denis Wojtek a écrit

Re: [GENERAL] Strange "missing tables" problem

; count >> --- >> 86703 >> (1 ligne) > > My table is there and I can access it !!! > > Any hint or help would be greatly appreciated ! > > I can do without it, but it's a little strange not to be able to list > the objects present in the database... Denis -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Strange "missing tables" problem

thout it but, it's a little strange not to be able to list the objects present in the database... Denis -- 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 execute external script from a TRIGGER or FUNCTION ?

unction that makes everything transparent to use the "local" postgresql customer database : SELECT * FROM hds_findcustomer(10234); This function : 1. Returns the customer if present in postgres 2. Otherwise executes the external script (check and update) 3. And returns the customer if updated Denis -- 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 execute external script from a TRIGGER or FUNCTION ?

Hello, Denis BUCHER a écrit : > I need to execute an external script from Postgresql, it could be in > perl, in bash/shell, in whatever... > > Any help would be appreciated ! I just need a very simple example if > possible... > > I already searched on the web but found no

[GENERAL] How to execute external script from a TRIGGER or FUNCTION ?

Hello everyone, I need to execute an external script from Postgresql, it could be in perl, in bash/shell, in whatever... Any help would be appreciated ! I just need a very simple example if possible... I already searched on the web but found nothing... Denis -- Sent via pgsql-general

Re: [GENERAL] Best way to import data in postgresl (not "COPY")

Hello everyone, Denis BUCHER a écrit : > I have a system that must each day import lots of data from another one. > Our system is in postgresql and we connect to the other via ODBC. > > Currently we do something like : > > SELECT ... FROM ODBC source > foreach row { >

[GENERAL] Best way to import data in postgresl (not "COPY")

... Does someone has a better suggestion ? Thanks a lot in advance ! Denis -- 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] origins/destinations

I m new to PostgreSQL so please tell me the drawbacks of is this solution Your Table 3 should not be a table it should be a array. CREATE TABLE table3 (     ori_des        int[][] ); for origin area_n and destination area_m if count is k, then ori_des[n][m] = k. --- On Tue, 19/5/09, Carso

Re: [GENERAL] Free Cache Memory (Linux) and Postgresql

Tom Lane ha scritto: > Denis Gasparin <[EMAIL PROTECTED]> writes: > >> I'm evaluating to issue the drop_caches kernel command (echo 3 > >> /proc/sys/vm/drop_caches) in order to free unused pagecache, directory >> entries and inodes. >> > &

[GENERAL] Free Cache Memory (Linux) and Postgresql

l problems of any kind. Any idea? Thank you in advance, Denis Gasparin Edistar SRL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] IN query operator and NULL values

instead returns only the value with not null values. I tested the example also in PostgreSQL 8.1 and it works correctly (two records). So the question is: what has changed from 8.1 to 8.2? Thank you in advance for your help, Denis -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Connection Pooling directly on Postgres Server

tc.. Ok. I knew that. I made the question because it seems that, for example, Oracle in release 11g is moving to a similar solution in order to solve connection pooling problems. For example look at the following link: http://pbarut.blogspot.com/2007/08/oracle-11g-drcp-databa

[GENERAL] Connection Pooling directly on Postgres Server

milar solution on postgres? What to do you think about this? Thank you, Denis ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Autovacuum not vacuuming pg_largeobject

x_fsm_pages is 2 (the default value). I suspect I must change this to a higher value... but how high should this value be? Thank you in advance, Denis ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] Autovacuum not vacuuming pg_largeobject

ogram. This program issues delete commands to the pg_largeobject table in order to erase the rows of the los no more referenced. Autovacuum is up and running... but now i'm thinking it doesn't examine system tables such as pg_largeobject... Am I wrong? Thank you, Denis ---

Re: [GENERAL] Question regarding autovacuum in 8.1

rmal log messages (instead of debug2)? I think it could be useful because in this way you can also know what tables are used more often then other... If i'm not wrong, the old autovacuum process in 7.4 and 8.0 did that... Denis

[GENERAL] Question regarding autovacuum in 8.1

rocessing because there aren't autovacuum info columns on pg_stat_all_tables (as there are for 8.2.x). Also I'm asking this because the size of the pg_clog is >200M and I am worried about possible transaction ID wraparound failures Thank you, Denis ---(end of

[GENERAL] Question regarding autovacuum in 8.1

because there aren't autovacuum info columns on pg_stat_all_tables (as there are for 8.2.x). Also I'm asking this because the size of the pg_clog is >200M and I am worried about possible transaction ID wraparound failures... Thank you, Denis Tom Lane ha scritto: > Karl Denninger <

[GENERAL] Data on NAS / NFS

ard to PostgreSQL performance and (more important) reliability? Thanks in advance. Regards, -- Jean-Denis Girard SysNux Systèmes Linux en Polynésie française http://www.sysnux.pf/ Tél: +689 483 527 / GSM: +689 797 527 ---(end of broadcast)--

[GENERAL] Postgresql over a SAN

1 and OS is linux with kernel 2.6. The server will be connected to the SAN using a 4Gb fibre channel link. Thank you in advance, Denis ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index

Re: [GENERAL] Strange behaviour with Xfs filesystem and unix_socket_directory

Setting PGHOST solved the problem! It was not clear to me that pg_ctl is actually a client and it doesn't read the configuration from postgresql.conf Thank you, Denis Tom Lane ha scritto: > Denis Gasparin <[EMAIL PROTECTED]> writes: > >> We configured the u

[GENERAL] Strange behaviour with Xfs filesystem and unix_socket_directory

and alive... Moreover this does not happen with other filesystems... Any idea? We're running 8.1.9 on Linux Ubuntu with kernel 2.6.17-11 and xfs progs 2.8.10-1 Thank you in advance for your help, Denis ---(end of broadcast)--- TIP 4: Hav

Re: [GENERAL] AutoVacuum Behaviour Question

o get rid of the temporary > tables. > RESET SESSION command is available only in 8.2 branch, isn't it? I tried to issue the command in a 8.1 server and the answer was: ERROR: unrecognized configuration parameter "session" Is there available a patch for the 8.1 version of postgresql? Thank you, Denis

[GENERAL] Prepared queries vs Non-prepared

sql_stmt_b7a713b0 AS select * from test where field=$1 EXECUTE [PREPARE: select * from test where field=$1] Speaking about postgresql performance... would not it be more efficient executing directly the query in the first case ($db->query) than preparing a statement without parameters and then

[GENERAL] Query that does not use indexes

n why Postgresql is using seqscan when it should not? I tryed also to vacuum analyze and reindex all the database but it didn't change anything. Thank you in advance, Denis Database and query infos The database is made of four tables. Here it is an extract of the definitition: table

Re: [GENERAL] Getting Text data as C string

Peter Eisentraut ha scritto: > Am Montag, 12. März 2007 12:47 schrieb Denis Gasparin: > >> I wrote a simple c stored procedure that accepts only one text parameter >> that i want to convert to a c string. >> The problem is that i obtain the C string correctly but with s

[GENERAL] Getting Text data as C string

- test12345678 I expected: NOTICE: (test12345678) test_text ------ test12345678 Where is the error? Thank you, Denis ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] does anyone have a tool to convert SP'sT-SQL to Postgres

Pavel is doing nice work on Orafce & the EnterpriseDB PG Community Fund is now sponsoring him to do more. On 2/10/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: Denis Lussier wrote: > Oracle provides a free tool for converting TSQL into PL/SQL. > > You can then u

Re: [GENERAL] does anyone have a tool to convert SP'sT-SQL to Postgres

Oracle provides a free tool for converting TSQL into PL/SQL. You can then use the PL/SQL on an EnterpriseDB database, if this doesn't work for ya... PL/SQL is quite a bit closer to PLpgSQL than TSQL is so you'll be well on your way. --Luss http://www.enterprisedb.com On 2/9/07, johnf <[EMAIL

[GENERAL] pg migrator

Korry Douglas has an EDB sponsored project called pg_migrator on pgfoundry. I believe it works for upgrading from 8.1 to 8.2 except for tables that use the ip address datatype. It works by just replacing the 8.1 system catalogs with the 8.2 system catalogs. I believe the on-disk images for 8.1

[GENERAL] EnterpriseDB Apology

Hi All, EnterpriseDB recently sent out email advertising new support offerings. Unfortunately, the email was incorrectly sent to some people who should not have received it. We apologize for the error, and are taking steps to avoid such mistakes in the future. -Denis Lussier CTO & Founder

[GENERAL] age(datfrozenxid) negative for template0. Is this normal?

possible if this is a problem or not... Thank you, Denis ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[GENERAL] Interval regression test failing with -march=pentium4

If i compile the -march=i586 the regression test reports no problems. Any tips? Thank you, Doct. Eng. Denis Gasparin --- Edistar Srl ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an

Re: [GENERAL] Size comparison between a Composite type and an

00.000 of records => 65.159.168 bytes numeric: 1.000.000 of records => 74.895.702 bytes text: 1.000.000 of records => 77.340.672 bytes The "text" table is only 16% larger than mycode one (I was expecting 100%!). Any idea? Thank you, Denis Douglas McNaught wrote: Denis Gaspari

Re: [GENERAL] Size comparison between a Composite type and an

indexed numeric and composite? Thank you, Denis Douglas McNaught wrote: [EMAIL PROTECTED] writes: I need to store very large integers (more of 30 digits). Er, What's wrong with the NUMERIC type? That can go up to hundreds of digits. -Doug ---(e

[GENERAL] Size comparison between a Composite type and an equivalent Text field

integer of 30 digits: Text Field 30 bytes + sizeof(text data structure) Composite type 8 bytes + sizeof(composite data structure) What of the two data structures (text or composite) will use more disk space? Thank you, -- Doct. Eng. Denis Gasparin --- Edistar srl

Re: [GENERAL] cannot stat `/usr/local/pgsql/data/pg_xlog/00000001000000430000009C': No such file or directory

Ok, I figured out how to get the archiver going again. This is what I have in the postgresql.conf file. archive_command = 'yblogger %p wrote in message news:[EMAIL PROTECTED] In my development system the file system where $PGDATA resides filled up. cp: writing `/usr/local/pgsql/archlog/ybcdr

[GENERAL] FW: cannot stat `/usr/local/pgsql/data/pg_xlog/00000001000000430000009C': No such file or directory

0009C to archive 2005-10-24 08:36:44 CDTLOG:  archive command "yblogger /usr/local/pgsql/data/pg_xlog/00010043009C     Postgresql version is:  PostgreSQL 8.0.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.1 (SuSE Linux)         From: Sailer, Denis (YBUSA-

[GENERAL] FW: cannot stat `/usr/local/pgsql/data/pg_xlog/00000001000000430000009C': No such file or directory

I forgot to include the specific error message related to the archival process not finding the file.       From: Sailer, Denis (YBUSA-CDR) [mailto:[EMAIL PROTECTED] Sent: Monday, October 24, 2005 8:52 AM To: pgsql-general@postgresql.org Subject: cannot stat `/usr/local/pgsql

[GENERAL] cannot stat `/usr/local/pgsql/data/pg_xlog/00000001000000430000009C': No such file or directory

In my development system the file system where $PGDATA resides filled up.   cp: writing `/usr/local/pgsql/archlog/ybcdrdbd01/data/000100430076': No space left on device could not copy /usr/local/pgsql/data/pg_xlog/000100430076 to archive 2005-10-23 08:46:29 CDTLO

Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase

Title: Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase It may be hard for u to resist if those wacky guyz from Redwood offered eight figures (and I'm not counting the ones to the right of the decimal point).   --Luss From: [EMAIL PROTECTED] on behalf of Marc G. FournierSent: Fri 10/

[GENERAL] mysql hash table equivalent?

Does postgres support in-memory only tables like the mysql HASH table type? I want to store some session data which I need quick access of, but don't care of it's lost on server stop/start ---(end of broadcast)--- TIP 9: In versions below 8.0, the

[GENERAL] Suggest forums software for postgresql?

Can anyone suggest good forums software to use with postgresql? I want to integrate the forums users into my website's user base with a view. I know of FudForums but it doesn't work well with views (the upgrade script in particular chokes very badly on them) and seems kinda buggy in general. The

[GENERAL] Limitations of PostgreSQL

the tables or database in PostgreSQL? Thanks in Advance, Regards, Denis 

[GENERAL] pg_dump for table with bytea takes a long time

I posted the following to the performance mailing list on 8/2/2005, but have not heard any replies. Maybe this should just be a general question.  Would someone be able to help me get pb_dump to run faster for bytea data?   ++   Dumping a database which c

Re: [GENERAL] Postgresql with max_connections=4096

With the last test I made, the database is swapping but in a very slow way... 100K every 10 minutes and that seems to not be a problem... in the sense that the server doesn't slow down... Today I'll make other tests and let you know. Thank you, Denis Scott Marlowe wrote: On We

Re: [GENERAL] Postgresql with max_connections=4096

r problems that I must to check. I think they are caused by my application. As soon as I have some results, I'll let you know. Thank you, Denis Jeff Trout wrote: On Jul 27, 2005, at 10:46 AM, [EMAIL PROTECTED] wrote: I'm now testing with pg_pool installed on each apache fr

Re: [GENERAL] Postgresql with max_connections=4096

er disk on another raid container. I'll let go the test for all the night and tomorrow I'll let you know the results... Thank you for your help, Denis Jeff Trout wrote: On Jul 27, 2005, at 4:22 AM, [EMAIL PROTECTED] wrote: Already checked. We set a machine with only pg_pool insta

Re: [GENERAL] Postgresql with max_connections=4096

that error but I obtain that error only after two/three hours of testing. Thank you for your help, Denis ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] Postgresql with max_connections=4096

not sure this is the only problem. Could anyone have suggestions or tips for the postgres configuration and the problem we're encountering? The postgresql version is 7.4.8 on a Dual Xeon with 4Gb of Ram. Apache frontends are Apache 1.3.33 with PHP 4.3.11. Thank you in

[GENERAL] Vacuum analyze question on estimated rows

In the following output the vacuum knows there are 99,612 pages and 1,303,891 rows.  However the last line of output during the analyze only thinks there are 213,627 rows.  Is this so far off because the table is bloated?  Version of PostgreSQL is “PostgreSQL 7.4.3 on i686-pc-linux-gnu, com

[GENERAL] CREATE INDEX failing; No space left on device; Database recycling itself

I was trying to create an index on a 37,000,000 row table and received the following error.  Evidently I don’t have enough space in my pg_xlog directory to handle this as a single transaction.  The file system for pg_xlog is allocated 2GB.   The following output is from a psql session direc

Re: [GENERAL] interval to seconds conversion. How?

On Wed, Oct 27, 2004 at 06:30:24PM -0400, Tom Lane wrote: > Denis Zaitsev <[EMAIL PROTECTED]> writes: > > How can I calculate the number of second in some interval? Neither > > the secods part, nor the seconds after midnight... Just the full > > quantity of the s

Re: [GENERAL] interval to seconds conversion. How?

On Thu, Oct 28, 2004 at 04:08:53AM +0600, Denis Zaitsev wrote: > How can I calculate the number of second in some interval? Neither > the secods part, nor the seconds after midnight... Just the full > quantity of the seconds. I haven't find any function. > > Thanks in adv

[GENERAL] interval to seconds conversion. How?

How can I calculate the number of second in some interval? Neither the secods part, nor the seconds after midnight... Just the full quantity of the seconds. I haven't find any function. Thanks in advance. ---(end of broadcast)--- TIP 7: don't for

[GENERAL] JDBC driver inserting into a table with Bytea type gets out of me mory error.

There was a posting in the mailing list archives that I can't find anymore.  The web site right now is presenting a list of items from a search in a reasonable amount of time, but takes 5-10 minutes to retrieve the detail for each one as they are clicked.  Rather frustrating.    This per

Re: [GENERAL] Cache lookup failure for pg_restore?

/tsearch/V2/regprocedure_7.4.patch.gz Best Regards - -- Denis -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-nr2 (Windows XP) iD8DBQFAniUSvsCA6eRGOOARAtJpAKCt4Wcrea3bIxu8fXw/5ZNFACdohwCfZPDf UuCk1dXLx8SCS4/qMniC2z4= =871m -END PGP SIGNATURE- ---(end of broadcast

Re: [GENERAL] vacuumdb is failing with NUMBER OF INDEX TUPLES NOT

g up the issue at the right time, however my main focus at that time was to bring the production system back to normal.. Regards - -- Denis -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-nr2 (Windows XP) iD8DBQFAnh+gvsCA6eRGOOARAlivAKCl8aIuii8GeSFLetWn+exBVXnptwCeKMUr wjAEgS7gP1LQeS/xZdiC03

Re: [GENERAL] vacuumdb is failing with NUMBER OF INDEX TUPLES NOT

t maybe someone else knows ? Regards - -- Denis -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-nr2 (Windows XP) iD8DBQFAnPzivsCA6eRGOOARAl1OAKC0zcgN409n7ylgyHV61J9/o4LsBgCgqEpJ yT24Y03fQItzhbRlxHyUg8s= =YBoz -END PGP SIGNATURE- ---(end of broadcast)

Re: [GENERAL] Smallint - Integer Casting Problems in Plpgsql functions

Hi Richard. Thank you for your reply. I rewrote the store procedure to accept integer instead of smallint. What i don't understand is why the casting is working in 7.2.3. What has been changed from that? Thank you, -- Doct. Eng. Denis Gasparin: [EMAIL PROT

Re: [GENERAL] Bug in pg_dumpall

I'm restoring it as the superuser. You can try to execute the commands directly from psql. Denis Doug McNaught wrote: Denis Gasparin <[EMAIL PROTECTED]> writes: Looking into the generated sql, i find that the schema is created with the command: CREATE USER aaa PASSWORD '

[GENERAL] Bug in pg_dumpall

schema is created with the command: CREATE USER aaa PASSWORD 'bbb' NOCREATEDB NOCREATEUSER; SET SESSION AUTHORIZATION aaa; CREATE SCHEMA aaa; This fails giving me the following error: ERROR: : permission denied Any ideas? I'm using Postgresql 7.3.4. -- Ing. Denis G

  1   2   >