On 30/03/2010 11:27 PM, Lothar Bongartz wrote:
For this reason the database is stalling from time to time and I have to
restart the server.
Are those stalls accompanied by any mention of checkpoints in the logs?
The default PostgreSQL configuration isn't tuned for larger workloads -
it's ver
Steve White wrote:
> This is a Samsung NC20. The goal is to use this machine for occasional
> testing of a database, but to keep its power consumption minimal.
>
> Intel powertop reports the second biggest cause of wakeups (after the
> network device ath) is postgres:
>
> Top causes for wakeups
The following bug has been logged online:
Bug reference: 5397
Logged by: Steve White
Email address: stevan_wh...@hotmail.com
PostgreSQL version: 8.4.2
Operating system: Ubuntu 10.5 beta
Description:powertop reports excessive wakeups
Details:
This is a Samsung NC20.
On Tue, Mar 30, 2010 at 12:22 PM, Kevin Grittner
wrote:
> [Did you mean to take this off-list, or was that accidental?]
Accidental.
>
> Chris Travers wrote:
>
>> With due respect, this sort of thing is rather difficult to get
>> right all at once.
>
> Division of two fixed-point numbers we alrea
I wrote:
> yielding some non-money numeric type (like perhaps float8).
Hmmm... Given that we've already had a couple posts on the idea
that dividing by '1'::money could convert money to something more
general, I guess it would be safer to stick to numeric.
-Kevin
--
Sent via pgsql-bugs mai
Chris Travers wrote:
> With due respect, this sort of thing is rather difficult to get
> right all at once.
The existing type is fixed point and we know how to add and subtract
two of them. I don't think it's all that difficult to add division,
yielding some non-money numeric type (like perha
Forgot to send to the list
On Tue, Mar 30, 2010 at 8:25 AM, Kevin Grittner
wrote:
> John R Pierce wrote:
>> Boszormenyi Zoltan wrote:
>
>>> But then any operator between two money values would
>>> only work if both values have the same currency.
>
> That sounds like a sane limitation.
>
>> a
"Lothar Bongartz" writes:
> For this reason the database is stalling from time to time and I have to
> restart the server. For the second time I have detected, that Postgres
> overwrites a table when shutting down. The table is only
> updated with NOW() and only for a single matching row:
> UPDAT
The following bug has been logged online:
Bug reference: 5395
Logged by: Lothar Bongartz
Email address: lotharbonga...@hotmail.com
PostgreSQL version: 8.4.3
Operating system: Windows Server 2003 R2
Description:UPDATE on shutdown overwrites table
Details:
I have port
Hi.
Ummm, it is very strange
Can you do chcp command?
C:\home\HIROSHI>chcp 932
現在のコード ページ: 932
Anyway, I want to prepare and check the same environment as you.
It may be that there is a shortage of environment for changing some.
the following things , but, It is hard to consider a problem.
John R Pierce wrote:
> Boszormenyi Zoltan wrote:
>> But then any operator between two money values would
>> only work if both values have the same currency.
That sounds like a sane limitation.
> and, are there still any currenccies like old style UK where
> the subunits aren't 100ths? sch
Boszormenyi Zoltan wrote:
> How about improving the money type so it can store
> values in different currencies?
Have you seen "taggedtypes"?
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via pgsql-bugs mai
John R Pierce írta:
> Boszormenyi Zoltan wrote:
>> Loading this dump into another database that happens
>> to have a different locale than hu_HU fails.
>>
>> But then any operator between two money values would
>> only work if both values have the same currency.
>>
>
> indeed, its all a big tarp
Boszormenyi Zoltan wrote:
Loading this dump into another database that happens
to have a different locale than hu_HU fails.
But then any operator between two money values would
only work if both values have the same currency.
indeed, its all a big tarpit. next, you'll want currency convers
Kevin Grittner írta:
> Andy Balholm wrote:
>
>
>> The ability to divide money by money would be useful for finding
>> what percent one money value is of another.
>>
>
> That certainly sounds useful and natural to me. I don't think it
> rises to the level of a *bug*, but it's a reasona
On 2010-03-30, Kevin Grittner wrote:
> Andy Balholm wrote:
>
>> The ability to divide money by money would be useful for finding
>> what percent one money value is of another.
>
> That certainly sounds useful and natural to me. I don't think it
> rises to the level of a *bug*, but it's a rea
16 matches
Mail list logo