Hi,
In the company, we're facing with serious disk space problems which is
not caused by PostgreSQL, but the nature of our data. Database sizes are
around 200-300GB, which is relatively not that much, but databases
require strict backup policies:
- Incremental backup for each day. (250GB)
- Full
On Mon, Dec 22, 2008 at 5:41 AM, Scott Marlowe scott.marl...@gmail.com wrote:
I think one of the points that proves this is the chunks of innovative
code that have been put into postgresql that were basically written by
one or two guys in 1 year. Small sharp teams can tackle one
particular
Jonah H. Harris wrote:
On Sun, Dec 21, 2008 at 11:02 PM, Scott Marlowe scott.marl...@gmail.com wrote:
The difference is HE put forth an opinion about the pg developers
being smarter, but you put forth what seems like a statement of fact
with no evidence to back it up. One is quite subjective
so, consider this one:
create sequence seq1;
create domain foo1 as bigint default nextval('seq1') not null;
create domain foo2 as timestamp without time zone default now() not null;
create type footype as
(
a foo1,
b foo2
) ;
create table bar(a bigint not null, b varchar(20));
insert into
On Mon, Dec 22, 2008 at 1:49 PM, Grzegorz Jaśkiewicz gryz...@gmail.com wrote:
but that defeats whole purpose of domains, doesn't it ?
well, on top of that - I could create another domain with default
(nextval, now), but still
Well I can't, it doesn't work :(
create domain xyz as footype
On Mon, Dec 22, 2008 at 7:37 AM, Geoffrey li...@serioustechnology.com wrote:
I still haven't seen a post regarding the Oracle scalability issue. Where is
the data??
You mean the PG scalability issue in comparison to Oracle?
--
Jonah H. Harris, Senior DBA
myYearbook.com
--
Sent via
Scott Marlowe escribió:
The difference is HE put forth an opinion about the pg developers
being smarter, but you put forth what seems like a statement of fact
with no evidence to back it up.
The other difference is that I said it jokingly, whereas you (Jonah)
seem to be bitter about the whole
I've such a structure:
create table catalog_fam (
famid int primary key,
name varchar(255),
action smallint
);
create table catalog_macro (
macroid int primary key,
famid int references catalog_fam (famid),
name varchar(255),
action smallint
);
create table catalog_cat (
catid int
On Mon, Dec 22, 2008 at 8:22 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
The other difference is that I said it jokingly, whereas you (Jonah)
seem to be bitter about the whole matter.
Well, it wasn't clear and I was just in a generally bad mood. Usually
you'd add a :) at the end,
In-Reply-to: 200812220435.mbm4zmd07...@momjian.us
On: Sun, 21 Dec 2008 23:35:48 -0500 (EST), Bruce Momjian
br...@momjian.us wrote:
I am sure there are smart people at all the database companies. I do
believe that open source development harnesses the abilities of its
intelligent people
On Mon, Dec 22, 2008 at 9:35 AM, James B. Byrne byrn...@harte-lyne.ca wrote:
I think that to describe either OS or commercial software as better or
worse is misleading. The most that can be said is that each approach
serves a different purpose and exists in a different environment.
Well said.
Jonah H. Harris wrote:
On Mon, Dec 22, 2008 at 7:37 AM, Geoffrey li...@serioustechnology.com wrote:
I still haven't seen a post regarding the Oracle scalability issue. Where is
the data??
You mean the PG scalability issue in comparison to Oracle?
Yes.
--
Until later, Geoffrey
Those who
On Mon, Dec 22, 2008 at 10:07:21AM +0200, Volkan YAZICI wrote:
Hi,
In the company, we're facing with serious disk space problems which
is not caused by PostgreSQL, but the nature of our data. Database
sizes are around 200-300GB, which is relatively not that much, but
databases require
On Dec 22, 2008, at 4:49 AM, Grzegorz Jaśkiewicz wrote:
so, consider this one:
create sequence seq1;
create domain foo1 as bigint default nextval('seq1') not null;
create domain foo2 as timestamp without time zone default now() not
null;
create type footype as
(
a foo1,
b foo2
) ;
Hi all,
I'd like to make a single query that returns a number of rows using a
'WHERE id IN (list-of-ids)' condition, but I'd like the rows to be
returned in the order in which the ids are given in the list.
Is this possible?
Sebastian
--
Sent via pgsql-general mailing list
My vacuum was follow error below:
WARNING: oldest xmin is far in the past
HINT: Close open transactions soon to avoid wraparound problems.
No have transactions in locked ,
what's could be happen?
Paulo Moraes
Veja quais são os assuntos do momento no Yahoo! +Buscados
Playing the straight man, I have to ask: Scalability issues with locks
in PG vs Oracle?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi all,
I'd like to make a single query that returns a number of rows using a
'WHERE id IN (list-of-ids)' condition, but I'd like the rows to be
returned in the order in which the ids are given in the list.
Is this possible?
Depending on how many IDs you have in your list, you can
Quoth Adam Rich ada...@sbcglobal.net:
I'd like to make a single query that returns a number of rows using a
'WHERE id IN (list-of-ids)' condition, but I'd like the rows to be
returned in the order in which the ids are given in the list.
Depending on how many IDs you have in your list, you can
On Mon, Dec 22, 2008 at 10:22 AM, paulo matadr saddon...@yahoo.com.br wrote:
My vacuum was follow error below:
WARNING: oldest xmin is far in the past
HINT: Close open transactions soon to avoid wraparound problems.
No have transactions in locked ,
Transactions don't have to hold locks
Hi,
I have somewhat of a quandary with a large table in my database;
PostgreSQL is choosing the 'wrong' index for a certain kind of query;
causing performance to become an order of magnitude slower (query times
usually measured in milliseconds now become seconds/minutes!).
It's not that it isn't
On Mon, 22 Dec 2008, David Fetter da...@fetter.org writes:
On Mon, Dec 22, 2008 at 10:07:21AM +0200, Volkan YAZICI wrote:
Hi,
In the company, we're facing with serious disk space problems which
is not caused by PostgreSQL, but the nature of our data. Database
sizes are around 200-300GB,
On Mon, Dec 22, 2008 at 12:34 PM, Christophe x...@thebuild.com wrote:
Playing the straight man, I have to ask: Scalability issues with locks in PG
vs Oracle?
(in slow motion) no. Locks aren't something particular I'd
like to discuss, this topic just came from a post upthread.
--
On Mon, Dec 22, 2008 at 6:10 PM, Erik Jones ejo...@engineyard.com wrote:
As mentioned above, by fixing the behavior to be what you're expecting
you'd be breaking the defined behavior of ALTER TABLE.
I don't understand. The domain's have default values, how will it
break alter table ? Please
Volkan YAZICI wrote:
On Mon, 22 Dec 2008, David Fetter da...@fetter.org writes:
On Mon, Dec 22, 2008 at 10:07:21AM +0200, Volkan YAZICI wrote:
15x4250 = 63750 = 62.25TB
SATA disk space is quite cheap these days, so unless something is very
badly wrong with your funding model, this is not
Shane Wright shane.wri...@edigitalresearch.com writes:
It's not that it isn't using any index (so enable_seqscan=off doesn't
help), it's that the index it picks is suboptimal.
The query is based on 3 of the table columns - there is an index on all
three, but it prefers to use an index on just
26 matches
Mail list logo