Thanks. I thought that there are some standard utilities or
sql request in postgres to view deleted or modified tuples.
2006/4/30, Steve Atkins <[EMAIL PROTECTED]>:
On Apr 29, 2006, at 4:18 PM, Robby Russell wrote:
>
> On Apr 29, 2006, at 12:49 PM, Dan Black wrote:
>
>> Hello
On Sat, Apr 29, 2006 at 07:05:35PM -0700, Steve Atkins wrote:
> >Just kidding... once you delete your records... they are gone.
>
> That's not true.
>
> Deleted (or modified) records don't go away until the space
> they use is recycled by the VACUUM command.
Well yes, but with autovacuum you
Hello all,
I'm working on a CMS which requires an open source database capable of
handling hundreds of thousands of users simultaneously, with a high
rate of database writes, and without buckling. We're talking somewhere
between nerve.com/catch27.com and xanga.com/friendster.com
PostgreSQL is a
On Sunday 30 April 2006 12:01, Tony Lausin wrote:
> Hello all,
>
> I'm working on a CMS which requires an open source database capable of
> handling hundreds of thousands of users simultaneously, with a high
> rate of database writes, and without buckling. We're talking somewhere
> between nerve.co
On 4/30/06, Tony Lausin <[EMAIL PROTECTED]> wrote:
Hello all,
I'm working on a CMS which requires an open source database capable of
handling hundreds of thousands of users simultaneously, with a high
rate of database writes, and without buckling. We're talking somewhere
between nerve.com/catch2
Hi All,
Could someone please help me out with an example on how to
define an operator and operator class that supports hash joins? I’ve
tried to follow the instructions in the documentation for v8.1 but I’m
obviously doing something wrong, because the engine crashes on an operation
that
On 4/30/06, Tony Lausin <[EMAIL PROTECTED]> wrote:
Hello all,
I'm working on a CMS which requires an open source database capable of
handling hundreds of thousands of users simultaneously, with a high
rate of database writes, and without buckling. We're talking somewhere
between nerve.com/catch2
"Tony Lausin" <[EMAIL PROTECTED]> writes:
> I'm working on a CMS which requires an open source database capable of
> handling hundreds of thousands of users simultaneously, with a high
> rate of database writes, and without buckling. We're talking somewhere
> between nerve.com/catch27.com and xanga
"Jozsef Szalay" <[EMAIL PROTECTED]> writes:
> Could someone please help me out with an example on how to define an
> operator and operator class that supports hash joins?
Well, for starters, only the equality operator should be marked HASHES,
and the support function for a hash opclass is complete
[ rotfl... ] MySQL will fall over under any heavy concurrent-write
scenario. It's conceivable that PG won't do what you need either,
but if not I'm afraid you're going to be forced into Oracle or one
of the other serious-money DBs.
regards, tom lane
Hi Tom,
That's a s
Very odd. I had always heard that MySql (at least originally) was a
"quick and dirty" database, easy to use, not fully standards compliant,
and not enterprise grade. Postgresql on the other hand was always
the heavyweight, standards compliant, enterprise db, which was more
difficult to use and s
In my opinion, postgresql is not the way to go when building a cMS
simply because of the way it handles strings.
A CMS should be language/region agnostic i.e. supporting any chosen
locale subset, rather then just one locale, as postgresql does. You
can throw UTF-8 at the problem and it will enabl
Tony Lausin wrote:
[ rotfl... ] MySQL will fall over under any heavy concurrent-write
scenario. It's conceivable that PG won't do what you need either,
but if not I'm afraid you're going to be forced into Oracle or one
of the other serious-money DBs.
That's a scary idea - being forced into Or
On Apr 30, 2006, at 12:23 PM, Tony Lausin wrote:
On the other hand, if you don't need multilang support, you'll find
that postgresql is generally great to program and use.
Tomislav
Hello Tomislav,
In my case, UTF-8 is a must. The site contextually will be directed to
North Americans, althou
I did something foolish and now I'm getting warnings every time
pg_dump runs (hourly from cron). Anybody have a suggestion on how
to fix this?
pg_dump: WARNING: owner of data type "accountuser" appears to be invalid
pg_dump: WARNING: owner of data type "adminuser" appears to be invalid
pg_dump: WA
I have a nested query that runs fine in psql but does not return
tabular data in PHP. I have built the query a step at a time and it
works as expected, even in PHP up to the point where I include the
second query, which uses a concatted string of field data to provide
row identity. I'm quite the PH
Hi,
On Sun, 2006-04-30 at 21:42 +, Rick Ellis wrote:
> I did something foolish and now I'm getting warnings every time
> pg_dump runs (hourly from cron). Anybody have a suggestion on how
> to fix this?
Create the user again with the same userid (I mean revert what you did).
You can get this i
In article <[EMAIL PROTECTED]>,
Devrim GUNDUZ <[EMAIL PROTECTED]> wrote:
>Create the user again with the same userid (I mean revert what you did).
>You can get this info from pg_tables and pg_authid(or pg_shadow,
>depending on your PostgreSQL version).
It turned out to be some tables had been cre
Hi,
I have a set of functions for a data type that return
small integers (i.e. [0..12]). I can, of course, represent
it as a char, short or long (CHAR, INT16 or INT32).
re there any advantages/drawbacks to chosing one particular
PG_RETURN_ type over another (realizing that they are
effectively j
Ahh. I see the point more clearly now. Perhaps the best strategy for
me is to press on with Postgres until the project is at a profitable
enough stage to merit a migration to Oracle - should Postgres become
an issue. I feel more confident about being able to migrate from
Postgres than from MySQL.
Oops! [EMAIL PROTECTED] ("Tony Lausin") was seen spray-painting on a wall:
> Ahh. I see the point more clearly now. Perhaps the best strategy for
> me is to press on with Postgres until the project is at a profitable
> enough stage to merit a migration to Oracle - should Postgres become
> an issue.
The open source offerings of ingres, ingres R3, runs the Wire section of our
business
http://www.onesteel.com
Allan
> > Postgres than from MySQL. I am financing this myself. hence the
> > apprehension about the cost. Is there another contender I
> > should think
> > about.
The material contai
22 matches
Mail list logo
