Re: [GENERAL] Unused item pointers - can someone explain?

On 26/11/2007, Elmer <[EMAIL PROTECTED]> wrote: > > On 23 Lis, 10:23, [EMAIL PROTECTED] ("Peter Childs") wrote: > > Yes, however > > > > found x removable > > > > have just been found and are now unused, so on the next run this number > will > > be added to the unused unless they get used again

Re: [GENERAL] Linux v.s. Mac OS-X Performance

On Tue, Nov 27, 2007 at 05:01:06PM -0700, Scott Ribe wrote: > > In general, you can expect any Unix based OS, which includes MacOS X, to > > perform noticeably better than Windows for PostgreSQL. > > Is that really true of BSD UNIXen??? I've certainly heard it's true of > Linux. But with BSD you h

Re: [GENERAL] System Load analyze

Am Dienstag 27 November 2007 schrieb Scott Marlowe: > On Nov 24, 2007 10:57 AM, Peter Bauer <[EMAIL PROTECTED]> wrote: > > i have a system here with 2 2.4GHz Xeon Processors, 2GB RAM, ONE Disk on > > a Battery Backed Write Cache SCSI Controller and PostgreSQL 8.1.4 > > running with the data on a DR

[GENERAL] I have a select statement on the issue.

I have a select statement on the issue. Following is the process I operate in four steps totally: Step 1:Create Table CREATE TABLE test ( code character varying(32) NOT NULL, name character varying(32) NOT NULL DEFAULT ''::character varying, qty integer NOT NULL DEFAULT 0, CONSTRAINT pk_tes

[GENERAL] WAL Recovery

Hello List Members, I have PostgreSQL 8.2.4 on Suse Linux Whne I am doing recovery from WAL archives I see in the logger that "01.history file not found" infact server has not created such file insted it created 01.backup file which contains the history which documents also suggest is

[GENERAL] client_encoding error

Whilst trying to migrate one of our tables to postgres we get the following error: invalid byte sequence for encoding "EUC_JP" : 0x9c32 HINT: This error can also happen if the byte sequence does not match the enccding expected by the server, which is cont roll

Re: [GENERAL] is the default of lowercase enforced on all OS platforms?

Kevin Kempter wrote: > Hi List; > > I know that the default case for postgres (psql) on Linux/*ix platforms is > lowercase. I wonder is this also true on Windows platforms? Yes. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://p

[GENERAL] is the default of lowercase enforced on all OS platforms?

Hi List; I know that the default case for postgres (psql) on Linux/*ix platforms is lowercase. I wonder is this also true on Windows platforms? Thanks in advance.. /Kevin ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

Re: [GENERAL] Linux v.s. Mac OS-X Performance

Doug McNaught <[EMAIL PROTECTED]> writes: > On Nov 27, 2007, at 8:36 PM, Gregory Stark wrote: >> I think (but I'm not sure) that the kernel in OSX comes from BSD. > Kind of. Mach is still running underneath (and a lot of the app APIs > use it directly) but there is a BSD 'personality' above it

Re: [GENERAL] Linux v.s. Mac OS-X Performance

> There are claims this > is improved in current systems (Leopard + Intel), but the margin was so > big before... IIRC, it was later established that during those tests they had fsync enabled on OS X and disabled on Linux. -- Scott Ribe [EMAIL PROTECTED] http://www.killerbytes.com/ (303) 722-056

Re: [GENERAL] Linux v.s. Mac OS-X Performance

> Kind of. Mach is still running underneath (and a lot of the app APIs > use it directly) but there is a BSD 'personality' above it which > (AIUI) is big parts of FreeBSD ported to run on Mach. Right. Also, to be clear, OS X is not a true microkernel architecture. They took the "division of respo

Re: [GENERAL] Linux v.s. Mac OS-X Performance

Only under Solaris. With Linux or BSD on it it ran pretty well. I had a Sparc 20 running RH 7.2 back in the day (or whatever the last version of RH that ran on sparc was) that spanked an Ultra-2 running slowalrus with twice the memory and hard drives handily. Solaris has gotten much better sinc

Re: [GENERAL] Linux v.s. Mac OS-X Performance

On Nov 27, 2007 8:05 PM, Ron Johnson <[EMAIL PROTECTED]> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 11/27/07 19:35, Greg Smith wrote: > [snip] > > to you. The minute performance becomes a serious concern, you'd be much > > better off with Linux, one of the BSDs that's not hobb

Re: [GENERAL] Linux v.s. Mac OS-X Performance

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/27/07 19:35, Greg Smith wrote: [snip] > to you. The minute performance becomes a serious concern, you'd be much > better off with Linux, one of the BSDs that's not hobbled by using the > Mach kernel, or one of the more serious UNIXes like Solari

Re: [GENERAL] Linux v.s. Mac OS-X Performance

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/27/07 19:36, Gregory Stark wrote: > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: [snip] > > That was true of the traditional BSD 4.3 and 4.4 design. However when people > refer to "BSD" these days they're referring to one of the major derivativ

Re: [GENERAL] Linux v.s. Mac OS-X Performance

On Nov 27, 2007, at 8:36 PM, Gregory Stark wrote: I think (but I'm not sure) that the kernel in OSX comes from BSD. Kind of. Mach is still running underneath (and a lot of the app APIs use it directly) but there is a BSD 'personality' above it which (AIUI) is big parts of FreeBSD ported

Re: [GENERAL] Another question about partitioning

Alex Vinogradovs wrote: Hello all, I have a table which is partitioned by range into 10 pieces with constraint exceptions. Constraint exceptions is enabled in server configuration too. For some reason, queries to the master table are still slower than direct queries against partitions. Is there

Re: [GENERAL] Linux v.s. Mac OS-X Performance

"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > On Tue, 27 Nov 2007 17:01:06 -0700 > Scott Ribe <[EMAIL PROTECTED]> wrote: > >> > In general, you can expect any Unix based OS, which includes MacOS >> > X, to perform noticeably better than Windows for PostgreSQL. >> >> Is that really true of BSD U

Re: [GENERAL] Linux v.s. Mac OS-X Performance

On Tue, 27 Nov 2007, Wolfgang Keller wrote: Anyway, how does MacOS X (both 10.4 and 10.5) compare to Windows (2000, XP, Vista etc.) on the same hardware? And Linux to (Free-/Net-/whatever) BSD? Apple hardware gets so expensive for some types of database configurations that such a comparision

Re: [GENERAL] Another question about partitioning

"Alex Vinogradovs" <[EMAIL PROTECTED]> writes: > Hello all, > > > I have a table which is partitioned by range into 10 pieces with > constraint exceptions. Constraint exceptions is enabled in server > configuration too. For some reason, queries to the master table > are still slower than direct qu

Re: [GENERAL] Linux v.s. Mac OS-X Performance

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/27/07 18:01, Scott Ribe wrote: >> In general, you can expect any Unix based OS, which includes MacOS X, to >> perform noticeably better than Windows for PostgreSQL. > > Is that really true of BSD UNIXen??? I've certainly heard it's true of > Lin

[GENERAL] Another question about partitioning

Hello all, I have a table which is partitioned by range into 10 pieces with constraint exceptions. Constraint exceptions is enabled in server configuration too. For some reason, queries to the master table are still slower than direct queries against partitions. Is there any real reason for that,

Re: [GENERAL] Linux v.s. Mac OS-X Performance

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 27 Nov 2007 17:01:06 -0700 Scott Ribe <[EMAIL PROTECTED]> wrote: > > In general, you can expect any Unix based OS, which includes MacOS > > X, to perform noticeably better than Windows for PostgreSQL. > > Is that really true of BSD UNIXen???

Re: [GENERAL] Linux v.s. Mac OS-X Performance

> In general, you can expect any Unix based OS, which includes MacOS X, to > perform noticeably better than Windows for PostgreSQL. Is that really true of BSD UNIXen??? I've certainly heard it's true of Linux. But with BSD you have the "kernel funnel" which can severely limit multitasking, regardl

Re: [GENERAL] spatial composition operators for PG

Jan- check out http://postgis.refractions.net/ M-- - Original Message - From: "Galkowski, Jan" <[EMAIL PROTECTED]> To: Sent: Tuesday, November 27, 2007 6:02 PM Subject: [GENERAL] spatial composition operators for PG Are there any standard spatial composition operators people use for P

[GENERAL] spatial composition operators for PG

Are there any standard spatial composition operators people use for PG's polygon and path data types? That is, it seems there ought to be extenders of the signatures, polygon <- polygon %+% (point, vertex-number) path <- path %+% (point, node-number) where the right-hand-sided point i

[GENERAL] Config settings for large restore

Hi, I'm just wondering what is considered the general wisdom on config setting for large pg_restore runs. I know to increase maintenance_work_mem and turn off autovacuum and stats collection. Shoule should checkpoint_segments and checkpoint_timeout be increased? Would twiddling shared_

[GENERAL] Unknown winsock error 10061while dumping a big database

I recently upgraded a 8.0 database to 8.2 (server is running windows 2003 server) and now I cannot dump the database any more. At some point in the dump, pg_dump (run on a centos 3 linux) return : pg_dump: Dumping the contents of table "c2674" failed: PQgetCopyData() failed.

Re: [GENERAL] Connection idle broken

On Nov 27, 2007 12:50 PM, Douglas McNaught <[EMAIL PROTECTED]> wrote: > On 11/27/07, Scott Marlowe <[EMAIL PROTECTED]> wrote: > > > > Actually, if you use the linux based ones, or download dd-wrt or > > openwrt and install that, the linksys routers are quite stable, > > reliable, and performant. >

Re: [GENERAL] Linux v.s. Mac OS-X Performance

On Tue, 2007-11-27 at 11:11 +0100, Wolfgang Keller wrote: > Hello, > > sorry for "butting in", but I'm just curious... > > > resolution? > > > > http://archives.postgresql.org/pgsql-general/2007-11/msg00946.php > > > > conclusion? > > > > Mac was still pretty slow in comparison > > Anyway, how

Re: [GENERAL] autovacuum process blocks without reporting a deadlock

"Thomas Chille" <[EMAIL PROTECTED]> writes: > I think this are the relevant pg_locks entries: > relation7568577875686189 > 9017862 25467 AccessShareLock f > relation7568577875686189 > 9009323 9317ShareU

Re: [GENERAL] Connection idle broken

On 11/27/07, Scott Marlowe <[EMAIL PROTECTED]> wrote: > On Nov 27, 2007 12:33 PM, Douglas McNaught <[EMAIL PROTECTED]> wrote: > > Get a better router then. Something between your clients and the > > database server is timing out those connections, and it's most likely > > that box--NAT connections

Res: [GENERAL] Connection idle broken

Right.. i'm sorry :-) i solved this problem according Scott Marlowe suggestion. I changed the postgresql.conf tcp_keepalives_idle = 300 tcp_keepalives_interval = 60 tcp_keepalives_count = 10 The connection don't broke more...Actually, the router linksys isn't good for network c

Re: [GENERAL] Connection idle broken

On Nov 27, 2007 12:33 PM, Douglas McNaught <[EMAIL PROTECTED]> wrote: > Get a better router then. Something between your clients and the > database server is timing out those connections, and it's most likely > that box--NAT connections are timed out fairly aggressively by default > on consumer ro

Re: [GENERAL] Connection idle broken

On 11/27/07, Fernando Xavier <[EMAIL PROTECTED]> wrote: > > > Hi, thanks for reply! > > No, my router don't have configurations for timeout connections.. Get a better router then. Something between your clients and the database server is timing out those connections, and it's most likely that box-

Re: [GENERAL] indexing tables using my owns functions

On Mon, Nov 26, 2007 at 04:54:10PM +0100, Pau Marc Munoz Torres wrote: > Hi every body > > Recently i wrote my own function into postgesql... and it works perfecly!!, > now i would like use it to index a table like this guy do at the link ( > http://www.faqs.org/docs/ppbook/r24254.htm) > > but i

Re: [GENERAL] Non-unique values problem after 'add column'

[EMAIL PROTECTED] writes: > I've encountered a very strange problem with Postgresql 7.3. 7.3.what? FWIW, I cannot replicate your problem using 7.3.20. It doesn't sound like any bug I can remember, but certainly there have been a lot of bugs fixed over the past five years.

Re: [GENERAL] Error while compiling PostgreSQL with Java

Thanks al for the answers !!! I solve my problem uninstalling source PostgreSQL and installed from binarys. I use JDBC driver from http://jdbc.postgresql.org/. Now all work fine. :) p.s. Unfortunately i dont solve problem how to compile postgreSQL with java but found very easy method to ins

Re: [GENERAL] \copy ... with null as '' csv doesn't get nulls

On Sun, 25 Nov 2007 13:22:48 -0500 Lew <[EMAIL PROTECTED]> wrote: > I went to the docs for COPY and they say, > > The default is \N (backslash-N) in text mode, and a empty value > > with no quotes in CSV mode. > That "with no quotes" phrase caught my attention. > Try eliminating the double quote

Re: [GENERAL] postgres 8.3 beta 2 storage question

> 1.How does postgres version 8.3 betat 2 handle varchar and numeric data > types in terms of storage > I understand for varchar it has 1byte overhead (instead of 4) if length<128 > How does it handle for numeric? The manual says > "The actual storage requirement is two bytes for each group of

Re: [GENERAL] Stored Procedures vs Dynamic SQL generated by ORM ?

On Mon, Nov 26, 2007 at 11:57:37PM -0800, Alagu Madhu wrote: > Which is the best Stored Procedures or Dynamic SQL generated by ORM ? This is roughly similar to the question, "Is it better to travel by car, boat, or plane?" It rather depends on what you're trying to accomplish. A -- Andrew Sul

Re: [GENERAL] Stored Procedures vs Dynamic SQL generated by ORM ?

On Nov 27, 2007 1:57 AM, Alagu Madhu <[EMAIL PROTECTED]> wrote: > > Which is the best Stored Procedures or Dynamic SQL generated by ORM ? Depends on what you mean by best. Dynamic SQL costs more in the planning stage because the db has to plan out each statement before running it. However, it ca

Re: [GENERAL] Non-unique values problem after 'add column'

On Nov 26, 2007 3:06 AM, <[EMAIL PROTECTED]> wrote: > Hello! > > I've encountered a very strange problem with Postgresql 7.3. > I have the following set of queries running in transaction, using > libpqxx 2.6.9: 7.3 is getting pretty old. I can't say anything though, I've still got a 7.4 db hangi

Re: [GENERAL] Why LIMIT and OFFSET are commutative

On Nov 26, 2007, at 5:29 AM, Andrus wrote: Under what interpretation would the results differ? Results must differ for easy creation of LinQ-PostgreSQL driver. If results are always the same , PostgreSQL should not allow to use both order of clauses. Nicholas explains: Assuming the ord

Re: [GENERAL] System Load analyze

On Nov 24, 2007 10:57 AM, Peter Bauer <[EMAIL PROTECTED]> wrote: > > i have a system here with 2 2.4GHz Xeon Processors, 2GB RAM, ONE Disk on > a Battery Backed Write Cache SCSI Controller and PostgreSQL 8.1.4 > running with the data on a DRBD Device for High Availability. The used > database is al

Re: [GENERAL] autovacuum process blocks without reporting a deadlock

"Thomas Chille" <[EMAIL PROTECTED]> writes: > Ah ok, 9293 is a triggerd process and tries to "ALTER TABLE ... > DISABLE TRIGGER (other trigger)" and so implicitly tries to acquire an > AccessExclusiveLock and runs in a deadlock? Well, you're certainly risking deadlock with that; and even if no act

Re: [GENERAL] Why LIMIT and OFFSET are commutative

"Andrus" <[EMAIL PROTECTED]> writes: >> Under what interpretation would the results differ? > > Results must differ for easy creation of LinQ-PostgreSQL driver. > If results are always the same , PostgreSQL should not allow to use both > order of clauses. > > Nicholas explains: > >Assuming the

Re: [GENERAL] select from an index

On Nov 27, 2007, at 3:15 AM, Pau Marc Munoz Torres wrote: Hi Recently i created an index in a table using a function (not a column) as following create index H2IAb on precalc (idr(p1,p4,p6,p7,p9,'H-2*IAb'));, now, i would like to perform a query using this index, something like Select

Re: [GENERAL] Unused item pointers - can someone explain?

On 23 Lis, 10:23, [EMAIL PROTECTED] ("Peter Childs") wrote: > Yes, however > > found x removable > > have just been found and are now unused, so on the next run this number will > be added to the unused unless they get used again in the mean time. > > The number ie the unused is the number of t

Re: [GENERAL] Linux v.s. Mac OS-X Performance

Hello, sorry for "butting in", but I'm just curious... resolution? http://archives.postgresql.org/pgsql-general/2007-11/msg00946.php conclusion? Mac was still pretty slow in comparison Anyway, how does MacOS X (both 10.4 and 10.5) compare to Windows (2000, XP, Vista etc.) on the same hard

[GENERAL] select from an index

Hi Recently i created an index in a table using a function (not a column) as following create index H2IAb on precalc (idr(p1,p4,p6,p7,p9,'H-2*IAb'));, where idr is a function that returns a real number, as a result i got the following table mhc2db=> \d precalc; Tab

Re: [GENERAL] replication in Postgres

> Sorry, this makes no sense to me -- EnterpriseDB has no replication > solution that I know of. slony is bundled with the database >> Postgres-r sounds very nice but moving our organisations data onto a >> system that it work in progress is very scary. > > You are already offloading your data to

[GENERAL] Stored Procedures vs Dynamic SQL generated by ORM ?

Hi All, Which is the best Stored Procedures or Dynamic SQL generated by ORM ? Thanks Madhu Alagu ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] Help Needed

Hi, Hope you all are doing gr8! I need a help regarding PostgreSQL installation. I am using PostgreSQL for a web-based application using Tomcat. I want to install PostgreSQL automatically to user system(using some EXE) with a default database(which is required for my application to run). The m

Re: [GENERAL] Error while compiling PostgreSQL with Java

Peter Eisentraut wrote: Никоноров Григорий wrote: I have a problem. I try to install PostgreSQL from source with java. I Installed JDK, ANT properly but when i try to configure i have an error - Warning.Ignored options - --with-java. Please help me ! PostgreSQL has no such option. You may be

Re: [GENERAL] Why LIMIT and OFFSET are commutative

> Under what interpretation would the results differ? Results must differ for easy creation of LinQ-PostgreSQL driver. If results are always the same , PostgreSQL should not allow to use both order of clauses. Nicholas explains: Assuming the ordering is the same on each of them (because Skip

Re: [GENERAL] Error while compiling PostgreSQL with Java

Никоноров Григорий wrote: I have a problem. I try to install PostgreSQL from source with java. I Installed JDK, ANT properly but when i try to configure i have an error - Warning.Ignored options - --with-java. Please help me ! Kris Jurka wrote: Starting with the 8.0 release the JDBC driver was

[GENERAL] indexing tables using my owns functions

Hi every body Recently i wrote my own function into postgesql... and it works perfecly!!, now i would like use it to index a table like this guy do at the link ( http://www.faqs.org/docs/ppbook/r24254.htm) but i get the following error mhc2db=> create index h2iab on precalc (idr(p1,p4,p6,p7,p9,

[GENERAL] System Load analyze

Hi all, i have a system here with 2 2.4GHz Xeon Processors, 2GB RAM, ONE Disk on a Battery Backed Write Cache SCSI Controller and PostgreSQL 8.1.4 running with the data on a DRBD Device for High Availability. The used database is also replicated to two similar machines with slony1. Since the loa

Re: [GENERAL] Why LIMIT and OFFSET are commutative

> That's SQL, my friend. OFFSET first, then LIMIT. Irrespective of the > order > in the query statement. It is what it is. SQL doesn't depend on LINQ for > its semantics. SQL requires strong order of all cases. Postgres syntax help about OFFSET / LIMIT also describes only single order. A

[GENERAL] Help Needed

Hi, Hope you all are doing gr8! I need a help regarding PostgreSQL installation. I am using PostgreSQL for a web-based application using Tomcat. I want to install PostgreSQL automatically to user system(using some EXE) with a default database(which is required for my application to run). The m

[GENERAL] Why LIMIT and OFFSET are commutative

I found that SELECT * FROM foo ORDER BY bar OFFSET n LIMIT m and SELECT * FROM foo ORDER BY bar LIMIT m OFFSET n produce always same results. Why ? OFFSET and LIMIT operations are NOT commutative in general. Andrus. ---(end of broadcast)---

Re: [GENERAL] Why LIMIT and OFFSET are commutative

Andrus wrote: I found that SELECT * FROM foo ORDER BY bar OFFSET n LIMIT m and SELECT * FROM foo ORDER BY bar LIMIT m OFFSET n produce always same results. Why ? OFFSET and LIMIT operations are NOT commutative in general. Under what interpretation would the results differ?

Re: [GENERAL] Why LIMIT and OFFSET are commutative

Andrus wrote: Under what interpretation would the results differ? Results must differ for easy creation of LinQ-PostgreSQL driver. If results are always the same , PostgreSQL should not allow to use both order of clauses. Um, no, and your original post had nothing to do with LINQ. My answer

[GENERAL] Non-unique values problem after 'add column'

Hello! I've encountered a very strange problem with Postgresql 7.3. I have the following set of queries running in transaction, using libpqxx 2.6.9: ALTER TABLE my_table ADD new_column TEXT UPDATE my_table SET new_column = 'disable' ALTER TABLE my_table ALTER COLUMN new_column SET DEFAULT 'disabl

Re: [GENERAL] Why LIMIT and OFFSET are commutative

Andrus wrote: Why Postgres does not throw error when SELECT ... LIMIT ... OFFSET is used ? That's not sql and should cause error. Good point, it is not standard SQL. Postgres varies from the standard in several ways, some of them useful. (INSERT ... RETURNING is a useful one.) No SQL RDBMS

Re: [GENERAL] \copy ... with null as '' csv doesn't get nulls

Ivan Sergio Borgonovo wrote: I'd expect this: \copy tablename from 'filename.csv' WITH NULL as '' CSV HEADER whould import "" as NULL. The input file is UTF-8 (not Unicode/UTF-16). I checked the hexdump and the "wannabe" NULL are actually 2c 22 22 2c -> ,"", all fields are varchar that admit

Re: [GENERAL] Error while compiling PostgreSQL with Java

Никоноров Григорий wrote: Thanks for your answer.When i [sic] download this "JDBC4 Postgresql Driver, Version 8.2-506" driver what should i do next to configure PostgreSQL with it ? Place the JAR containing the driver in the classpath for your Java application. In the Java program be sure to

Re: [GENERAL] autovacuum process blocks without reporting a deadlock

On Nov 27, 2007 4:52 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > You didn't happen to note what 9293 was doing did you? It's living > fairly dangerously in any case by trying to acquire exclusive lock > when it already holds a bunch of other lower-level locks; that's a > recipe for deadlock if I eve

Re: [GENERAL] ERROR: invalid restriction selectivity: 224359728.000000

> > error message in log: > > ERROR: invalid restriction selectivity: 0.49 > > [ blink... ] Surely it didn't really say that, because a moment's > glance at the code shows that it's impossible: > > if (result < 0.0 || result > 1.0) > elog(ERROR, "invalid restriction select

Re: [GENERAL] autovacuum process blocks without reporting a deadlock

yes, u are right. this are the 3 involved indexes: hst_timerecording_business_day_idx on hst_timerecording hst_timerecording_id_employee_idxon hst_timerecording hst_timerecording_id_timerecording_idxon hst_timerecording lg t On Nov 27, 2007 4:07 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > A

Re: [GENERAL] Connection idle broken

On Nov 27, 2007 8:33 AM, Fernando Xavier <[EMAIL PROTECTED]> wrote: > Hi, > > I have trouble with my java application. Since i change the network > configuration, the postgresql idle connections broken after 10 minutes. (i > set authentication_timeout = 600 in postgresql.conf). > > My network: >

Re: [GENERAL] autovacuum process blocks without reporting a deadlock

Alvaro Herrera wrote: > Thomas Chille wrote: > > On Nov 27, 2007 3:14 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > > hat are the column headings? I find this difficult to read. > > > > > > Please post the whole of pg_locks. I may be missing something but I > > > think we're missing part of the

Re: [GENERAL] autovacuum process blocks without reporting a deadlock

Thomas Chille wrote: > On Nov 27, 2007 3:14 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > hat are the column headings? I find this difficult to read. > > > > Please post the whole of pg_locks. I may be missing something but I > > think we're missing part of the picture here. Autovacuum does no

Re: [GENERAL] Connection idle broken

On 11/27/07, Fernando Xavier <[EMAIL PROTECTED]> wrote: > > Hi, > > I have trouble with my java application. Since i change the network > configuration, the postgresql idle connections broken after 10 minutes. (i > set authentication_timeout = 600 in postgresql.conf). > > My network: > > 192.168.1

[GENERAL] postgres 8.3 beta 2 storage question

Hi, 1.How does postgres version 8.3 betat 2 handle varchar and numeric data types in terms of storage I understand for varchar it has 1byte overhead (instead of 4) if length<128 How does it handle for numeric? The manual says "The actual storage requirement is two bytes for each group of fo

Re: [GENERAL] autovacuum process blocks without reporting a deadlock

On Nov 27, 2007 3:14 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote: hat are the column headings? I find this difficult to read. > > Please post the whole of pg_locks. I may be missing something but I > think we're missing part of the picture here. Autovacuum does not seem > to be locking on anyth

[GENERAL] Connection idle broken

Hi, I have trouble with my java application. Since i change the network configuration, the postgresql idle connections broken after 10 minutes. (i set authentication_timeout = 600 in postgresql.conf). My network: 192.168.1.1 (postgresql server and gateway server) 192.168.0.1 (linksys wireles

Re: [GENERAL] autovacuum process blocks without reporting a deadlock

Thomas Chille wrote: > I think this are the relevant pg_locks entries: > > relation7568577875686189 > 9017862 25467 AccessShareLock f > relation7568577875686189 > 9009323 9317ShareUpdateExclusiveLock >

Re: [GENERAL] autovacuum process blocks without reporting a deadlock

On Nov 24, 2007 6:20 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > What other indexes does that table have? > > regards, tom lane > Hi, last night it happend again. In the log-snippet u can see all indexes of this table: [9293 / 2007-11-26 21:46:28 CET]CONTEXT: SQL statement

[GENERAL] "Invalid Pointer Operation" while reading tuples

Hello, I'm receiving an error message "Invalid pointer operation" when I'm reading data from my database. I'm using PostGreSQL 8.2.5 with Windows 2003 Server Enterprise Edition. When I saw the psqlodbc log I found teh messages below: [11.281]CONN ERROR: func=PGAPI_SetConnectOption, desc='', errn

Re: [GENERAL] select using an index

Pau Marc Munoz Torres írta: Hi Recently i created an index in a table using a function (not a column) as following create index H2IAb on precalc (idr(p1,p4,p6,p7,p9,'H-2*IAb'));, where idr is a function that returns a real number, as a result i got the following table mhc2db=> \d precalc;

[GENERAL] select using an index

Hi Recently i created an index in a table using a function (not a column) as following create index H2IAb on precalc (idr(p1,p4,p6,p7,p9,'H-2*IAb'));, where idr is a function that returns a real number, as a result i got the following table mhc2db=> \d precalc; Tab

Re: [GENERAL] Linux v.s. Mac OS-X Performance

Hello, sorry for "butting in", but I'm just curious... resolution? http://archives.postgresql.org/pgsql-general/2007-11/msg00946.php conclusion? Mac was still pretty slow in comparison Anyway, how does MacOS X (both 10.4 and 10.5) compare to Windows (2000, XP, Vista etc.) on the same hard

Re: [GENERAL] Trigger problem

Thanks for pinpointing that out. After including your solution it shows at least something like "UPDATE OF with id: 123456567". Unfortunately after using coalesce, too, when building the field variable like: field = 'field gruppe from: ' || coalesce(OLD.gruppe, '') || ' TO ' || coalesce(NEW.gruppe

Re: [GENERAL] Trigger problem

am Tue, dem 27.11.2007, um 10:38:09 +0100 mailte Christian Rengstl folgendes: > Hi list, > > act = 'DELETION of row with id: ' || OLD.id; > act = 'UPDATE OF ' || field || ' with id: ' || > ... > INSERT INTO history(aennam, action, table_name) VALUES(current_user, > act, ta

[GENERAL] Trigger problem

Hi list, I have a trigger to log what the users do on the database: DECLARE _query VARCHAR; DECLARE valid BOOL; DECLARE act VARCHAR; DECLARE tab VARCHAR; DECLARE field VARCHAR; BEGIN IF(TG_OP = 'DELETE') THEN act = 'DELETION of row with id: ' || OLD.id; ELSIF(TG_OP = 'UPDATE') THEN IF N

[GENERAL] cp: cannot stat `/mnt/server/archivedir/00000001.history': No such file or directory

HECKPOINT LOCATION: 0/5320 START TIME: 2007-11-27 13:59:44 IST LABEL: /mnt/server/base_backup/20071127 STOP TIME: 2007-11-27 14:00:09 IST *** last WAL when server was shut down was 0001