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
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
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
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
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
> 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
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
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
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
>>
>>
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
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 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 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
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
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
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
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
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
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
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 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 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
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
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
>
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
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 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
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
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
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
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
[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
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
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
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
"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
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
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
>> 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
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
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
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
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
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, 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
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
> 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
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
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
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 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
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
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
- "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
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
>
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
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
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
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
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
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
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, 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
63 matches
Mail list logo
