On Tue, 20 Oct 2009, Craig Ringer wrote:
You made an exact image of each drive onto new, spare drives with `dd'
or a similar disk imaging tool before trying ANYTHING, right? Otherwise,
you may well have made things worse, particularly since you've tried to
resync the array. Even if the data wa
On Wed, Oct 21, 2009 at 12:10 AM, Greg Smith wrote:
> On Tue, 20 Oct 2009, Ow Mun Heng wrote:
>
>> Raid10 is supposed to be able to withstand up to 2 drive failures if the
>> failures are from different sides of the mirror. Right now, I'm not sure
>> which drive belongs to which. How do I determi
On Tue, 20 Oct 2009, Ow Mun Heng wrote:
Raid10 is supposed to be able to withstand up to 2 drive failures if the
failures are from different sides of the mirror. Right now, I'm not
sure which drive belongs to which. How do I determine that? Does it
depend on the output of /prod/mdstat and in
Hi,
While attending a Linux conference, a guy said that 10,923 lines of
code are added and 5,547 lines of code are deleted per day in average
in Linux development. This is an interesting number and I just wonder
anybody ever tries to calculate these numbers with PostgreSQL.
Does anyone know such
John wrote:
Hi,
Is it better to create multi databases or create multi schemas?
John, I just gave a talk on multi-tenant Pg clusters at PgConf West
2009 that may help you but ran into vehicle problems and just got home
this evening. As quick as I can I'll get the bits-and-pieces pulled
to
2009/10/21 Merlin Moncure :
> On Tue, Oct 20, 2009 at 5:12 PM, Pavel Stehule
> wrote:
>>> [ shrug... ] There are other possible reasons why the planner would
>>> fail to flatten a subquery, but none of them apply to the example you
>>> showed. And your example function *was* VOLATILE, by defaul
On Tuesday 20 October 2009 11:59:54 am Rich Shepard wrote:
> On Tue, 20 Oct 2009, John wrote:
> > I never even considered using the one database with added company
> > field/column. On the surface is sounds OK but I'm not to sure. Each SQL
> > statement would require company_id. H.
>
> Johnf
On Tue, Oct 20, 2009 at 5:12 PM, Pavel Stehule wrote:
>> [ shrug... ] There are other possible reasons why the planner would
>> fail to flatten a subquery, but none of them apply to the example you
>> showed. And your example function *was* VOLATILE, by default.
>
> I checked this on 8.5 and fun
Hello
2009/10/19 Tom Lane :
> Gerhard Wiesinger writes:
>> On Mon, 19 Oct 2009, Tom Lane wrote:
>>> Probably because you have the function declared VOLATILE.
>
>> None of the function is declared VOLATILE. Any other idea?
>
> [ shrug... ] There are other possible reasons why the planner would
>
- "Sim Zacks" wrote:
> >> According to the documentation, numeric is stored without any
> leading
> >> or trailing zeros.
> >>
> >
> > That says *stored*; it doesn't say *displayed*.
> >
> > regards, tom lane
> >
> If it displays them, it has to know they exist. T
2009/10/20 Sim Zacks :
> I guess that's a matter of interpretation. To me zeros after a decimal
> point without anything else after them are extra.
>From a mathematical perspective, they most certainly are not extra.
15.000
15.001
15.002
15.003
Each have three digits of precision, and each mean
2009/10/20 Alban Hertroys :
> You miss a keyword in your query in renameTable; it should be " RENAME TO ",
> not " TO ".
Thanks for spotting that. I've made my amendments for next submit.
> Wouldn't it be convenient to have an EXPLAIN ANALYSE version of explain()?
> Maybe with a boolean paramete
On Tue, 20 Oct 2009, John wrote:
I never even considered using the one database with added company
field/column. On the surface is sounds OK but I'm not to sure. Each SQL
statement would require company_id. H.
Johnf,
Why not take a look at the sql-ledger code? It's a series of perl
On Tuesday 20 October 2009 10:11:53 am Wolfgang Keller wrote:
> > Is it better to create multi databases or create multi schemas?
>
> You're missing one option imho: One database, one schema.
>
> > I am writing a program that can have multi instances. Sort like a
> > finanical accounting system th
On 20 Oct 2009, at 14:02, Thom Brown wrote:
If anyone has a moment, could they review the PostgreSQL driver I
wrote for Joomla's next major release? The developers at Joomla have
listened to the persistent noise created about only having MySQL as an
option and are now accepting submissions for
dario@libero.it wrote:
> Hello,
>
> I'm looking for a function to count the occurrences of a pattern in a
> string. E.g. something like:
>
> fun_count_pattern('fooXblaX', 'X')
>
> which would
> return 2 (I.e. pattern 'X' found 2 times in string 'fooXblaX').
How about:
test=*# select le
> Is it better to create multi databases or create multi schemas?
You're missing one option imho: One database, one schema.
> I am writing a program that can have multi instances. Sort like a finanical
> accounting system that can have multiable companies. Where each company has a
> different
Hello,
I'm looking for a function to count the occurrences of a pattern in a
string. E.g. something like:
fun_count_pattern('fooXblaX', 'X')
which would
return 2 (I.e. pattern 'X' found 2 times in string 'fooXblaX').
I could write
my own function for this (probably using plpython?) but I was
On Tue, 20 Oct 2009, Christophe Pettus wrote:
On Oct 20, 2009, at 8:32 AM, Viktor Rosenfeld wrote:
@Christophe, I enjoyed your talk very much, particularly because I
learned about pgfouine, which from the looks of it, will make my current
project vastly simpler. So, thank you.
You should re
On Oct 20, 2009, at 8:32 AM, Viktor Rosenfeld wrote:
@Christophe, I enjoyed your talk very much, particularly because I
learned about pgfouine, which from the looks of it, will make my
current
project vastly simpler. So, thank you.
You should really thank Josh Berkus; he's the one who gave
On Tue, 20 Oct 2009, Waldomiro wrote:
So, I put in sharedbuffers the same size my two biggest tables, which are the
most read too. 11 GB + 4 GB. total shared buffers = 15 GB
That seems quite reasonable. The rest of the unused RAM in the server is
going to be used by the operating system cach
And there I thought I was considerate when I didn't post during the
week-end.
It's also curious that "some gratitude is in order" while the developers
owe us nothing. (Not that I think they do, I just think those two
attitudes contradict each other.)
@Christophe, I enjoyed your talk very much, p
the bytea limit is 1gb (as are all datums in postgres).
pg_largeobject can go up to 2gb, but in either case you'd likely run
into severe performance/scalability issues long before objects began
approaching those size because of memory usage and other issues. With
100kb objects though, you shoul
Hi,
I suppose the same is true for the time logged with log_duration, i.e.
it does not include the time needed to transfer the data to the client?
Or is it more like \timing in that respect?
Cheers,
Viktor
Craig Ringer wrote:
> EXPLAIN ANALYZE measures the time taken to execute the query. It d
>> According to the documentation, numeric is stored without any leading
>> or trailing zeros.
>>
>
> That says *stored*; it doesn't say *displayed*.
>
> regards, tom lane
>
If it displays them, it has to know they exist. That means it stores it
somewhere.
> The part
On Tue, Oct 20, 2009 at 4:22 PM, Waldomiro wrote:
> Hi everybody,
>
> I have some doubts about sharedmemory and work_mem.
>
> I have a server:
>
> 64 GB RAM
> 2 processors 4 cores each one intel xeon 3 Ghz
> expecting 300 users in the same time
>
> So, I put in sharedbuffers the same size my two
Hi everybody,
I have some doubts about sharedmemory and work_mem.
I have a server:
64 GB RAM
2 processors 4 cores each one intel xeon 3 Ghz
expecting 300 users in the same time
So, I put in sharedbuffers the same size my two biggest tables, which
are the most read too. 11 GB + 4 GB. total sha
"Ow Mun Heng" writes:
> [resend w/ plain text only - Sorry]
> right sibling's left-link doesn't match: block 121425 links to 124561
> instead of expected 121828 in index
> Oct 20 22:21:29 hmweb5 postgres[8795]: [3-2] "d_trh_trr_water_eval_pkey"
> What does the above mean?
It means you've got a
On Tue, Oct 20, 2009 at 07:56:48AM -0400, Martin Gainty wrote:
>
> Wolfgang
>
> I am compiling 8.4.1 and am seeking any/all architecture
> documents..right now the architecture (relationship of classes) i
> see is extracted from makefile dependencies An architecture document
> will detail the lay
Craig Ringer writes:
> Anyway, let me make sure I understand what you are saying. After you
> reboot the server, just after the PostgreSQL service has started up,
> there are several minutes where some (but not all) client connections
> tend to time out. After that initial problem period, things s
Sim Zacks writes:
>>> I'm not sure offhand what is the easiest way to suppress trailing
>>> zeroes, but casting to plain numeric is not the route to a solution.
> According to the documentation, numeric is stored without any leading
> or trailing zeros.
That says *stored*; it doesn't say *displa
[resend w/ plain text only - Sorry]
right sibling's left-link doesn't match: block 121425 links to 124561
instead of expected 121828 in index
Oct 20 22:21:29 hmweb5 postgres[8795]: [3-2] "d_trh_trr_water_eval_pkey"
WARNING: terminating connection because of crash of another server process
DETA
right sibling's left-link doesn't match: block 121425 links to 124561
instead of expected 121828 in index
Oct 20 22:21:29 hmweb5 postgres[8795]: [3-2] "d_trh_trr_water_eval_pkey"
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has comman
On Tue, Oct 20, 2009 at 08:02:06AM +0200, Viktor Rosenfeld wrote:
> Hi,
>
> I second the request for the files refered to in the video --
> particularly postgresql.conf.simple and dependencies.
Folks,
Christophe provides his very specialized professional services /pro
bono/. Please stop treatin
On 20/10/2009 05:55, Nate Randall wrote:
> I am new to Postgre, having formerly used Filemaker Pro. I need to
> import CSV files into Postgre which contain some empty string "" values
> in several date-type fields. I am able to import the CSV files into
> Postgre with the COPY FROM command if the
Thanks for you reply!
Server and the client conect with the same CISCO switch.
We have checked the switch ,but no CRC error occur.
This issue always occur after we reboot the server and the postgres service
just become ready statu for serval several minutes.
It is possible that server's performan
I am new to Postgre, having formerly used Filemaker Pro. I need to import
CSV files into Postgre which contain some empty string "" values in several
date-type fields. I am able to import the CSV files into Postgre with the
COPY FROM command if the datefields are converted to text fields in
Postg
When I try to initiliase a new database from command prompt i get the
following message.
"C:\Program Files\PostgreSQL\8.2\bin>initdb -D d:\data\postgres\dbnew
The program "postgres" is needed by initdb but was not found in the
same directory as "C:\Program Files\PostgreSQL\8.2\bin/initdb".
Check
I have checked the items below but they are all correct including the
shared-memory setting.
/Anders
Richard Huxton wrote:
>
> el dorado wrote:
>> Hello.
>> I had such an error but rather long ago. Unfortunately I don't remember
>> all the details but you could try to do the followig:
>> - c
2009/10/20 Merlin Moncure :
> On Tue, Oct 20, 2009 at 8:02 AM, Thom Brown wrote:
>> If anyone has a moment, could they review the PostgreSQL driver I
>> wrote for Joomla's next major release? The developers at Joomla have
>> listened to the persistent noise created about only having MySQL as an
>
Hi,
Is it better to create multi databases or create multi schemas?
I am writing a program that can have multi instances. Sort like a finanical
accounting system that can have multiable companies. Where each company has a
different name but the tables are an exact match to each other. IOW the
On Tue, Oct 20, 2009 at 8:02 AM, Thom Brown wrote:
> If anyone has a moment, could they review the PostgreSQL driver I
> wrote for Joomla's next major release? The developers at Joomla have
> listened to the persistent noise created about only having MySQL as an
> option and are now accepting sub
2009/10/20 Reid Thompson :
> your attachment contains this...
>
>
> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
> http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">
>
> 403 - Forbidden
>
>
> 403 - Forbidden
>
>
>
Erk.. that's weird. I got that too even af
On Tuesday 20 October 2009 3:39:22 am Sim Zacks wrote:
> Numeric with scale precision always shows the trailing zeros.
> Numeric plain only shows numbers after the decimal point that are being
> used.
>
>
> That statement is false:
>
> regression=# select 1234.000::numeric;
> numeric
> --
2009/10/20 Csaba Nagy :
> Hi Thom,
>
> I would like to review it, but I get "403 - Forbidden" when clicking:
>
> http://downloads.joomlacode.org/trackeritem/4/5/0/45041/postgresql.php
>
> Not sure what that means, probably I need some kind of login to the
> joomla tracker system, and I don't have o
Hi Thom,
I would like to review it, but I get "403 - Forbidden" when clicking:
http://downloads.joomlacode.org/trackeritem/4/5/0/45041/postgresql.php
Not sure what that means, probably I need some kind of login to the
joomla tracker system, and I don't have one, and I would prefer not to
create
If anyone has a moment, could they review the PostgreSQL driver I
wrote for Joomla's next major release? The developers at Joomla have
listened to the persistent noise created about only having MySQL as an
option and are now accepting submissions for alternative database
systems. (see
http://grou
Wolfgang
I am compiling 8.4.1 and am seeking any/all architecture documents..right now
the architecture (relationship of classes) i see is extracted from makefile
dependencies
An architecture document will detail the layout of the System Tables and their
classes(sorry as neither C++/java is no
2009/10/20 Dave Page :
> PGDay.EU 2009 is approaching fast - have you registered yet?
>
> Europe's premier PostgreSQL conference organised by PostgreSQL Europe
> and PostgreSQLfr will be held on November 6th and 7th at ParisTech
> Telecom in Paris, France. With an outstanding lineup of talks over t
PGDay.EU 2009 is approaching fast - have you registered yet?
Europe's premier PostgreSQL conference organised by PostgreSQL Europe
and PostgreSQLfr will be held on November 6th and 7th at ParisTech
Telecom in Paris, France. With an outstanding lineup of talks over the
two days of the event, with t
On 20/10/2009 6:51 PM, Luca Ferrari wrote:
> On Tuesday 20 October 2009 10:44:13 am Scott Marlowe's cat walking on the
> keyboard wrote:
>> Two things. 1: Actually running the query and receiving the results
>> isn't the same as just running it and throwing them away (what explain
>> analyze does
On 20/10/2009 4:41 PM, Scott Marlowe wrote:
>> I have a 4 disk Raid10 array running on linux MD raid.
>> Sda / sdb / sdc / sdd
>>
>> One fine day, 2 of the drives just suddenly decide to die on me. (sda and
>> sdd)
>>
>> I've tried multiple methods to try to determine if I can get them back
>> onl
On 20/10/2009 3:01 PM, 黄永卫 wrote:
> Thanks for you reply!
> Server and the client conect with the same CISCO switch.
OK, so they're both on the same local network segment, with the same
subnet and IP address range, connected via a single Ethernet switch?
Guess it's probably not the network.
> Thi
On Tuesday 20 October 2009 10:44:13 am Scott Marlowe's cat walking on the
keyboard wrote:
> Two things. 1: Actually running the query and receiving the results
> isn't the same as just running it and throwing them away (what explain
> analyze does) and 2: The query may be getting cached in psql i
2009/10/20 Grzegorz Jaśkiewicz
>
>
> On Tue, Oct 20, 2009 at 11:27 AM, Wolfgang Keller wrote:
>
>> > I'am searching for a free tool to design a Postgre Database. There is
>> > something similar to MySQL Workbench?
>>
>> http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
>>
>>
Numeric with scale precision always shows the trailing zeros.
Numeric plain only shows numbers after the decimal point that are being
used.
That statement is false:
regression=# select 1234.000::numeric;
numeric
--
1234.000
(1 row)
I'm not sure offhand what is
On Tue, Oct 20, 2009 at 11:27 AM, Wolfgang Keller wrote:
> > I'am searching for a free tool to design a Postgre Database. There is
> > something similar to MySQL Workbench?
>
> http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
>
> I've tried out nearly every (affordable or f
> I'am searching for a free tool to design a Postgre Database. There is
> something similar to MySQL Workbench?
http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
I've tried out nearly every (affordable or free) ER tool that's available and
so far the one I like the most is
Hi
You can also try Mogwai ERDesignerNG. Free and Open Source.
Regards
Mirko
> -Ursprüngliche Nachricht-
> Von: "Peter Hunsberger"
> Gesendet: 19.10.09 22:52:50
> An: Andre Lopes
> CC: pgsql-general@postgresql.org
> Betreff: Re: [GENERAL] Free Tool to design Postgres Databases
> On M
On Tue, Oct 20, 2009 at 2:34 AM, Luca Ferrari wrote:
> Hi all,
> I'm testing a proprietary driver that connects my old applications to a
> postgresql database. The problem is that I've got very strange issues about
> execution times. For instance, the following query:
>
> cogedb=> explain analyze
On Tue, Oct 20, 2009 at 1:11 AM, Ow Mun Heng wrote:
> Sorry guys, I know this is very off-track for this list, but google hasn't
> been of much help. This is my raid array on which my PG data resides.
>
> I have a 4 disk Raid10 array running on linux MD raid.
> Sda / sdb / sdc / sdd
>
> One fine d
Hi all,
I'm testing a proprietary driver that connects my old applications to a
postgresql database. The problem is that I've got very strange issues about
execution times. For instance, the following query:
cogedb=> explain analyze SELECT * FROM GMMOVART WHERE DATA >= '01/01/2006'
AND DATA
Sorry guys, I know this is very off-track for this list, but google hasn't
been of much help. This is my raid array on which my PG data resides.
I have a 4 disk Raid10 array running on linux MD raid.
Sda / sdb / sdc / sdd
One fine day, 2 of the drives just suddenly decide to die on me. (sda and
63 matches
Mail list logo