Hello,
Did someone fix the double iteration in the buffer cache code as discussed
at in the meantime:
http://www.mail-archive.com/pgsql-general@postgresql.org/msg137230.html
Thnx.
Ciao,
Gerhard
--
http://www.wiesinger.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
On 09/01/2010 11:22 PM, Bayless Kirtley wrote:
About twice per month, it is necessary to reset the modem and router. This,
of course, loses the manager's connection to the DB.
With modern OSes, and many much older ones, it's not "of course" at all.
Windows XP Pro is quite odd in that it break
On 09/01/10 7:40 PM, Scott Marlowe wrote:
On Wed, Sep 1, 2010 at 3:52 PM, John R Pierce wrote:
however, that user shouldn't show up on the "Welcome" friendly style login
screen.OTOH, I'm not sure what mechanism is used to prevent this.
ah, a little googling... on 32bit windows.. registry
On Wed, Sep 1, 2010 at 3:52 PM, John R Pierce wrote:
> however, that user shouldn't show up on the "Welcome" friendly style login
> screen. OTOH, I'm not sure what mechanism is used to prevent this.
>
> ah, a little googling... on 32bit windows.. registry entry
>
> HKEY_LOCAL_MACHINE\SOFTWARE\M
Hi.
Um, it is very strange.
Can you send us the mylog of psqlODBC?
Regards,
Hiroshi Saito
> Hi Hiroshi
>
>The same program works on the server unchanged - that's why I think it
>is something to do with the driver. The error message says that the
>field name doesn't exist when it does as can
On Wed, 2010-09-01 at 16:59 -0400, Tom Lane wrote:
> It would help if Devrim could break down the bloat to the level of
> individual tables/indexes.
While setting up this data (by anonymizing table names, etc), I saw that
almost all relations are smaller on backup server, as compared to prod.
Yea
On 09/01/10 2:01 PM, Alvaro Herrera wrote:
Excerpts from Luka Novak's message of mié sep 01 06:35:13 -0400 2010:
hello!
I just recently installed PostgreSQL for my HoldemManager application, and
after a restart, there was actually a new windows user account named postgre
on the startup along
On Wed, 2010-09-01 at 17:32 -0400, Tom Lane wrote:
> But are you sure there aren't some fillfactor tweaks in there too?
I'm sure. fillfactor related changes are on the radar, but I did not
commit them yet...
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= writes:
> Alvaro, this may be a stupid question but: I enabled custom autovac
> settings for some tables. These changes are included in the dump. May
> this affect on-disk size?
Doesn't seem likely that that would matter to the state immediately
after restoring;
Hi Hiroshi
The same program works on the server unchanged - that's why I think it
is something to do with the driver. The error message says that the
field name doesn't exist when it does as can be verified by looking at
the database in Postgresql.
Cheers
Phil Jackson
On 9/2/2010 3:19 AM,
On Wed, 2010-09-01 at 16:50 -0400, Alvaro Herrera wrote:
> Devrim didn't specify the platform on each server AFAICS.
Both are Red Hat /CentOS 5.5, x86_64, running with identical software
versions...
I first inclined to blame LVM+storage, however I could duplicate this
issue on local disks, too. T
Excerpts from Luka Novak's message of mié sep 01 06:35:13 -0400 2010:
> hello!
>
>
> I just recently installed PostgreSQL for my HoldemManager application, and
> after a restart, there was actually a new windows user account named postgre
> on the startup along with my admin account for windows (
Alvaro Herrera writes:
> Excerpts from Richard Huxton's message of mié sep 01 16:39:55 -0400 2010:
>> OK - so not fillfactor and not some unicode-related padding. I can't see
>> how a 32 vs 64-bit architecture change could produce anything like a
>> doubling of database size.
> Depending on ta
Excerpts from Richard Huxton's message of mié sep 01 16:39:55 -0400 2010:
> OK - so not fillfactor and not some unicode-related padding. I can't see
> how a 32 vs 64-bit architecture change could produce anything like a
> doubling of database size.
Depending on table schemas, why not? e.g. con
On 01/09/10 21:32, Devrim GÜNDÜZ wrote:
On Wed, 2010-09-01 at 21:13 +0100, Richard Huxton wrote:
Could you have changed the fillfactor on some big tables/indexes in
the live database after populating them?
Nope. Even a pg_dump -h prod|psql backup_node resulted with the same
issue
Is the lo
Hi,
On Wed, 2010-09-01 at 21:13 +0100, Richard Huxton wrote:
>
> Could you have changed the fillfactor on some big tables/indexes in
> the live database after populating them?
Nope. Even a pg_dump -h prod|psql backup_node resulted with the same
issue
> Is the locale the same on each machine/db
On 31/08/10 22:17, Devrim GÜNDÜZ wrote:
I have seen the opposite of this tons of times before, but I haven't
seen an increase after restore before. Does anyone know what may cause
this? Where should I look at?
Could you have changed the fillfactor on some big tables/indexes in the
live databas
Arjen Nienhuis writes:
> If I create a DEFERRED ON DELETE CASCADE constraint, it doesn't really work
> as I expected. I expected it to defer the deletion to the end of the
> transaction, but it dosn't.
Yeah, this is per SQL spec as far as we can tell. Constraint checks can
be deferred till end o
On Thu, 2010-09-02 at 14:04 +1200, Phil Jackson wrote:
> Does anyone have any suggestions?
>
What does the ODBC log say?
What does the PostgreSQL Log (or event viewer) say?
JD
> Cheers
>
> Phil Jackson
>
>
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.c
On Wed, Sep 01, 2010 at 10:22:20AM -0500, Bayless Kirtley wrote:
> About twice per month, it is necessary to reset the modem and router. This,
> of course, loses the manager's connection to the DB. The problem is, it also
> seems to break the connection at the cash register. The next time it trie
Hi,
If I create a DEFERRED ON DELETE CASCADE constraint, it doesn't really work
as I expected. I expected it to defer the deletion to the end of the
transaction, but it dosn't.
Is there a way to replace the contents of a table which has foreign keys?
There's no MERGE/UPSERT/whatever either.
On 09/01/10 16:13, Igor Neyman wrote:
-Original Message-
From: Raymond C. Rodgers [mailto:sinful...@gmail.com]
Sent: Tuesday, August 31, 2010 7:56 PM
To: pgsql-general@postgresql.org
Subject: Table update problem works on MySQL but not Postgres
update mydemo set cat_order = cat_orde
On 01/09/10 16:22, Bayless Kirtley wrote:
I have a two-user point-of-sale application on Windows XP PRO. The DB
runs
on the cash register. The second user is a manager's computer. They are
connected through a wired router which is also connected to an internet
cable modem. The manager's compute
I have a two-user point-of-sale application on Windows XP PRO. The DB runs
on the cash register. The second user is a manager's computer. They are
connected through a wired router which is also connected to an internet
cable modem. The manager's computer just checks statistics on the DB and
mai
Hi.
There is very little information which explores a problem.
What thing is an actual error message?
The following is my imagination
As for specific field, it may be the LOWER problem of a character.
example)
-- CREATE TABLE xx("Field" TEXT);
postgres=# SELECT Field FROM xx;
ERROR:
On Wed, Sep 1, 2010 at 5:20 AM, Paul Newman wrote:
> Hi,
> Could someone out there help me.
> Given the following set of values
> +3
> +3
> 0
> +3
> +3
> -3
> 0
> +3
>
> I want to have a maximum sum of 6 at any one point , in other words I want
> the following
>
>
> +3 -- 3
> +3 -- 6
> 0 --
hello!
I just recently installed PostgreSQL for my HoldemManager application, and
after a restart, there was actually a new windows user account named postgre
on the startup along with my admin account for windows (if i didnt make it
clear -- the account to log in to windows, before windows start
Hi,
Could someone out there help me.
Given the following set of values
+3
+3
0
+3
+3
-3
0
+3
I want to have a maximum sum of 6 at any one point , in other words I want the
following
+3 -- 3
+3 -- 6
0 -- 6
+3 -- 6
+3 -- 6
-3 -- 3
0 -- 3
+3 -- 6
How can I do this ?
Thank you
Thanks, Tom
Can this be clarified in docs? It is stated there now that scalar subquery
is one of the kinds of expressions
and it is somewhat counter-intuitive that an expression may sometimes not
respect its own degree of volatility.
On Wed, Sep 1, 2010 at 2:16 AM, Tom Lane wrote:
> Vyacheslav
> -Original Message-
> From: Raymond C. Rodgers [mailto:sinful...@gmail.com]
> Sent: Tuesday, August 31, 2010 7:56 PM
> To: pgsql-general@postgresql.org
> Subject: Table update problem works on MySQL but not Postgres
>
> Let me stress that this is not a bug in PostgreSQL; if
> anyth
2010/9/1 Devrim GÜNDÜZ :
> On Tue, 2010-08-31 at 18:08 -0600, Scott Marlowe wrote:
>> ny chance you've restored to different dbs
>> and have two copies? Or double the data in one db?
>
> Nope. This is a single database, and I restored only once.. # of rows in
> tables match to the ones in prod...
On Tue, 2010-08-31 at 18:08 -0600, Scott Marlowe wrote:
> ny chance you've restored to different dbs
> and have two copies? Or double the data in one db?
Nope. This is a single database, and I restored only once.. # of rows in
tables match to the ones in prod...
--
Devrim GÜNDÜZ
PostgreSQL Danı
Dear all,
First of all Sorry If i break any rule while posting this problem.
I have a table named *naxalite_entity1(source_id integer,obj_type_id
integer,obj_text character varying).
*It has the following form of data
45454545 1 Adarsh
45454545 1 Rahul
45454545 1 Yahoo
45454545 3 College
454
Hi,
>From the docs I see that you can control null values being sorted
before or after all non-null-values using 'NULLS LAST' or 'NULLS
FIRST' in the order by clause.
The default behaviour is to act as though nulls are larger than non-nulls.
My question is, is there a way to configure this defau
34 matches
Mail list logo