On Mon, 28 Mar 2005, Alvaro Herrera wrote:
On Mon, Mar 28, 2005 at 07:24:24PM +0400, Oleg Bartunov wrote:
On Mon, 28 Mar 2005, Alvaro Herrera wrote:
On Mon, Mar 28, 2005 at 10:09:19AM +0400, Oleg Bartunov wrote:
On Sun, 27 Mar 2005, Jim C. Nasby wrote:
Maybe it's just me, but it's pretty hard to re
On Mon, 28 Mar 2005, Jim C. Nasby wrote:
It'd probably be helpful to include this info in a document to go along
with the image.
I'll do this unless more experienced (Bruce, Elein) writers do that.
On Mon, Mar 28, 2005 at 07:16:23PM +0400, Oleg Bartunov wrote:
On Mon, 28 Mar 2005, Mark Woodward wr
On Mon, Mar 28, 2005 at 07:24:24PM +0400, Oleg Bartunov wrote:
> On Mon, 28 Mar 2005, Alvaro Herrera wrote:
>
> >On Mon, Mar 28, 2005 at 10:09:19AM +0400, Oleg Bartunov wrote:
> >>On Sun, 27 Mar 2005, Jim C. Nasby wrote:
> >>
> >>>Maybe it's just me, but it's pretty hard to read, especially at the
On Mon, Mar 28, 2005 at 10:09:19AM +0400, Oleg Bartunov wrote:
> On Sun, 27 Mar 2005, Jim C. Nasby wrote:
>
> >Maybe it's just me, but it's pretty hard to read, especially at the top.
>
> what do you mean ? Too crowdy or text is too small ?
It's just too hard to grok what the relationships are.
It'd probably be helpful to include this info in a document to go along
with the image.
On Mon, Mar 28, 2005 at 07:16:23PM +0400, Oleg Bartunov wrote:
> On Mon, 28 Mar 2005, Mark Woodward wrote:
>
> >>Hi there,
> >>
> >>while learning inkscape I did a sketch of picture describing
> >>history of r
I wrote:
> I've been toying with the idea of converting the oidvector and
> int2vector datatypes from fixed-width arrays to variable-length;
> that is, stick a varlena length word on the front and store only
> pronargs or indnatts entries instead of a fixed number.
I have a prototype patch that do
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> I don't see how this is a showstopper. At creation time we may decree
> that the database is "incomplete", and users can't normally connect to
> it; we only allow that after a phase of correcting minor issues, such as
> reindexing if necessary. I recal
On Mon, Mar 28, 2005 at 10:54:16AM -0500, Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > Maybe it would work if we forced indexes on shared relations to be
> > scanned using a fixed collation.
>
> The shared relations only have indexes on name, oid, and integer:
> select distinct
Alvaro, Tom,
> > Very likely we could kick it up to 100 or so without feeling any pain;
> > how high were you thinking?
>
> I used to see people asking to raise it to 64 or so. ÂNot sure if it
> would be useful to go higher than that ... much less now that we have
> full-fledged support for row ty
Alvaro Herrera <[EMAIL PROTECTED]> writes:
Maybe it would work if we forced indexes on shared relations to be
scanned using a fixed collation.
The shared relations only have indexes on name, oid, and integer:
select distinct atttypid::regtype
from pg_class c join pg_attribute a on c.oid = a.attreli
On Mon, Mar 28, 2005 at 12:16:42PM +0400, Alexey Slynko wrote:
> this patch allow to use database locale settings. It remove cluster locale
> settings, and append LCCTYPE and
> LCCOLLATE items to CREATE DATABASE syntax.
>
> Any considerations ?
The problem with this is what happens to indexes o
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Maybe it would work if we forced indexes on shared relations to be
> scanned using a fixed collation.
The shared relations only have indexes on name, oid, and integer:
select distinct atttypid::regtype
from pg_class c join pg_attribute a on c.oid = a.at
> On Mon, 28 Mar 2005, Mark Woodward wrote:
>
>>> Hi there,
>>>
>>> while learning inkscape I did a sketch of picture describing
>>> history of relational databases. It's available from
>>> http://mira.sai.msu.su/~megera/pgsql/
>>
>> Is there a direct line from INGRES to Postgres? I was under the
>
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> Further data point - the expected result appears when I set the sleep
> interval at 1 minute, but not at 40 secs. That does indicate that the
> stats collector is actually running and doing its job (kinda).
Hmm ... maybe the intentional sleep in the s
On Mon, 28 Mar 2005, Alvaro Herrera wrote:
On Mon, Mar 28, 2005 at 10:09:19AM +0400, Oleg Bartunov wrote:
On Sun, 27 Mar 2005, Jim C. Nasby wrote:
Maybe it's just me, but it's pretty hard to read, especially at the top.
what do you mean ? Too crowdy or text is too small ?
I found it a little confus
On Mon, 28 Mar 2005, Mark Woodward wrote:
Hi there,
while learning inkscape I did a sketch of picture describing
history of relational databases. It's available from
http://mira.sai.msu.su/~megera/pgsql/
Is there a direct line from INGRES to Postgres? I was under the impression
that Postgres is a "
Andrew Dunstan wrote:
As far as the test failure, maybe we are just not allowing enough time
for the stats collector to run? The thing sits there for 2 sec, which
theoretically is plenty, but it's a busy-wait loop and if the Cygwin
scheduler is not aggressive about taking away timeslices then may
On Mon, Mar 28, 2005 at 12:16:42PM +0400, Alexey Slynko wrote:
> this patch allow to use database locale settings. It remove cluster locale
> settings, and append LCCTYPE and
> LCCOLLATE items to CREATE DATABASE syntax.
>
> Any considerations ?
The problem with this is what happens to indexes
On Mon, Mar 28, 2005 at 12:27:18PM +0500, imad wrote:
> I want to know is there any way to execute an anonymous PL/pgSQL block
> in PostgreSQL.
No, there isn't.
--
Alvaro Herrera (<[EMAIL PROTECTED]>)
Al principio era UNIX, y UNIX habló y dijo: "Hello world\n".
No dijo "Hello New Jersey\n", ni
On Mon, Mar 28, 2005 at 10:09:19AM +0400, Oleg Bartunov wrote:
> On Sun, 27 Mar 2005, Jim C. Nasby wrote:
>
> >Maybe it's just me, but it's pretty hard to read, especially at the top.
>
> what do you mean ? Too crowdy or text is too small ?
I found it a little confusing. Do the lines go one way
> Hi there,
>
> while learning inkscape I did a sketch of picture describing
> history of relational databases. It's available from
> http://mira.sai.msu.su/~megera/pgsql/
Is there a direct line from INGRES to Postgres? I was under the impression
that Postgres is a "new" lineage started after INGR
--On söndag, mars 27, 2005 20.11.48 +0200 Magnus Hagander
<[EMAIL PROTECTED]> wrote:
As for general collation of unicode, the reason for me to use
ICU is that
my system does not support strcoll correctly for multibyte
locales, as I
mentioned earlier. I also noted that even for systems that do ha
On Sun, 2005-03-27 at 23:12 -0500, Jaime Casanova wrote:
> On Sat, 19 Mar 2005 11:42:18 +, Simon Riggs <[EMAIL PROTECTED]> wrote:
> > I can see that I might want the view to have a different default value
> > from that of the underlying table. I can see a reason to have multiple
> > updateable
23 matches
Mail list logo
