[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

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

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

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

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] 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] 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] 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

[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

[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

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] 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] 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] 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

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

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] 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] 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] 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] 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] 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

[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

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

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

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

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

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

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

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

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

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

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

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

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 ???

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

[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

[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

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: > > >

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

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

in advance Denis Gasparin --- Edistar SRL

[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

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

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

[GENERAL] Odd behaviour in update rule

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

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

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

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

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

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?

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

[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

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. >> > &

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

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

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: [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] 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] 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

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

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

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

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

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

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] 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] 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

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] 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] 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

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] Re: Perfomance decreasing

updates it is not an issue too (I mean if do not update more than 25% of DB each day). Actually for anyone listening for such advices I would recommend to create a test installation, and stress test it before go to production. Interbase has its own problems. -- Sincerely Yours, Denis Perchi

[GENERAL]

new_table WHERE col1 = 'value'. The problem is that when i do an explain this is the query plan: Seq Scan on new_table (cost=0.00..1116.38 rows=500 width=44) Can anyone explain me why it doesn't use the index I have created? Thank you for you help

Re: [GENERAL]

It contains 5 records. I have to do vacuum analyze on the table after having issued the "CREATE INDEX" to create the index? Please, let me know... Regards, Denis At 19.03 23/08/01, Doug McNaught wrote: >Denis Gasparin <[EMAIL PROTECTED]> writes: > > > Hi to all

Re: [GENERAL]

27;ll check what the statistics say about the SELECT on the primary key query. When i've done, i'll tell you... Denis At 19.03 23/08/01, Doug McNaught wrote: >Denis Gasparin <[EMAIL PROTECTED]> writes: > > > Hi to all! > > I have created a table using the

Re: [GENERAL]

Now i have tried creating the table and the inserting... The results are the same... Is it possible that the query planner thinks that is best a sequential scan when an index on the table is present? I'm using postgresql 7.1.3 on a redhat 7.1. Thanks for the help, Denis P.S.: I'm so

[GENERAL] BIGINT datatype and Indexes Failure

sql 7.1.2 on RedHat 7.1. All the regress tests has been completed correctely during installation. Please, let me know as soon as possible... Regards, Eng. Denis Gasparin: [EMAIL PROTECTED] --- Programmer & System Administrator - Edistar srl

Re: [GENERAL] BIGINT datatype and Indexes Failure

solved in some future release At this point, is it safe to use BIGINT datatype and indexes on those fields? Thank for your answers, Regards, Eng. Denis Gasparin: [EMAIL PROTECTED] --- Programmer & System Administrator - Edistar srl At 14.57 24/08/01, Denis Gasp

[GENERAL] General database programming question

g to your experience? Is there others different solutions? Thank for the tips... Regards, Eng. Denis Gasparin: [EMAIL PROTECTED] --- Programmer & System Administrator - Edistar srl ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Recreating indices safely

On Wednesday 19 September 2001 11:25, Tom Lane wrote: > Denis Perchine <[EMAIL PROTECTED]> writes: > > BTW, using begin; lock table; create index;drop index;commit; is not > > working, > > ?? > > regression=# create table foo (f1 text); > CREATE > re

[GENERAL] URGENT ! Nouveau virus

Hello ! Ok... I wrote a small text against that virus just in case you need it ! http://www.horus.ch/virus180901.txt A bientôt ! Denis Bucher ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [GENERAL] URGENT ! Nouveau virus

... All my apologies and happy postgresql'ing :-) Denis ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Recreating indices safely

On Wednesday 19 September 2001 11:25, Tom Lane wrote: > Denis Perchine <[EMAIL PROTECTED]> writes: > > BTW, using begin; lock table; create index;drop index;commit; is not > > working, > > ?? > > regression=# create table foo (f1 text); > CREATE > re

Re: [GENERAL] VACUUM, 24/7 availability and 7.2

e link... In conclusion, the new VACUUM command as described above will be include in the 7.2 version of Postgresql? Denis Gasparin: [EMAIL PROTECTED] --- Programmer & System Administrator - Edistar srl ---(end of broadcast)--

Re: [GENERAL] VACUUM, 24/7 availability and 7.2

e link... In conclusion, the new VACUUM command as described above will be include in the 7.2 version of Postgresql? Denis Gasparin: [EMAIL PROTECTED] --- Programmer & System Administrator - Edistar srl ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [GENERAL] VACUUM, 24/7 availability and 7.2

Ok, little language qui pro quo... I'm sorry for the error... Denis At 15/10/01 17.00, Andrew Sullivan wrote: >On Mon, Oct 15, 2001 at 10:40:17AM +0200, Denis Gasparin wrote: > > > > > >It's long since done. > > > > ==>> This means that it wil

  1   2   >