Hi,
I was looking for a open source CRM, PHP or python based, with a large
community where Postgresql is a first class citizen.
I'd prefer ease of use over features.
Thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it http://www.borgonovo.net
--
Sent via pgsql-general mailing
ns" tend to
support postgres better.
Python would be absolutely welcome, but I don't have that much
experience managing Java on the web.
https://www.odoo.com/ supports postgres but it is an ERP and it is far
more complicated than I would like.
--
Ivan Sergio Borgonovo
http://www.we
tryton.org/ (EPR) very postgres oriented, same family of odoo
supporting postgres.
Still looking for some good advice.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it http://www.borgonovo.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your su
e on Github and if not
to contribute I'll surely give a look to learn something.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it http://www.borgonovo.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
It can decouple DB schema from the application or it can increase the
coupling.
Choosing JS for performance in the stored procedure realm is going to
encourage coupling and make scalability harder and it is going to become
a mess when you'll need to refactor.
[1] https:/
fields are varchar that admit NULL
but still I get empty strings ('') in spite of NULL.
Am I missing something or it is a well known "feature"?
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
en't too many chances
of weird stuff in 2000 records (sed -e 's/,""/,/g').
Anyway with NULL AS '' and without it I can't still import NULL
without pre-processing.
I thought it may be missing total support of UTF-8 or if I did
something wrong or it is actual
ed the "NULL AS"
> >> clause in your COPY statement.
>
> Ivan Sergio Borgonovo wrote:
> > Exactly what I did because fortunately there weren't too many
> > chances of weird stuff in 2000 records (sed -e 's/,""/,/g').
>
> And this
orks.it/d1/page/postgresql_inheritance_surprises
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
more secure
> products, but the reality is that with software, you are on your
> own. Any company telling you otherwise as a reason not to use open
> source is lying.
It would be curious to see it happening indeed.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
more secure
> products, but the reality is that with software, you are on your
> own. Any company telling you otherwise as a reason not to use open
> source is lying.
It would be curious to see it happening indeed.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
not found then
insert into _table (uid, aid, qty)
values(_uid,_aid,_qty);
end if;
end;
' language plpgsql;
Is it going to perform worse than with a static table name?
Where can I find some clue about the effects of similar decisions?
thx
--
Ivan S
On Mon, 03 Dec 2007 19:06:29 +
Richard Huxton <[EMAIL PROTECTED]> wrote:
> Ivan Sergio Borgonovo wrote:
> > Any general rule about dynamically generated queries in stored
> > procedures vs. performances?
>
> It's the same decision as any with any prepared pl
ing for
developers:
http://www.gtsm.com/oscon2003/toc.html
Starting from Functions
Still I can't understand some things, I'll come back.
thanks for the right pointers.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
certain results and get everything
> working first.
At the end... if you don't look to much to details everything will
reach a defined deterministic state after all ;)
> Note that this is quite old now, so some performance-related
> assumptions will be wrong for current versions of
re is no OWNED BY in 8.1, is there any other way to
auto-drop sequences when columns get dropped?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
ak int not null
);
insert into temp1 (fk1,ak) select
insert into DESTtable2 (pk2,fk1,...)
select (pk2,fk1...) from SRC2
join temp1 ...
);
alter sequence seq_DESTtable2 RESTART currval('seq_temp1');
But it looks awful.
--
Ivan Sergio Borgonovo
http://w
>
> do work perfectly.
What if boolean_column is NULL?
btw set bolean_column= not bolean_column works "as expected".
template1=# select (not 't'::boolean),(not 'f'::boolean),(not
NULL::boolean);
?column? | ?column? | ?column?
--+---
ull,
> take care of it somewhere else but not here.
That is the "as expected" part.
The "case" case, other than being more verbose, do more than what I
would expect since all NULL are converted to t.
template1=# select case when NULL then 'f'::boolean els
ues(3,3);
insert into pippo values(4,3);
insert into pippo values(5,1);
insert into pippo values(1,10);
insert into pippo values(7,6);
select type_id, count(*) from pippo group by type_id having
count(*)=1;
10;1
6;1
2;1
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
-
h kind of dump people on this list lose the chance to read
interesting stuff about Postgres, SQL and DB.
[1] In general; commonly; extensively, __though not universally__;
most frequently.
BTW it is not a case that Computer Science and *Information*
Technology are strict relat
h kind of dump people on this list lose the chance to read
interesting stuff about Postgres, SQL and DB.
[1] In general; commonly; extensively, __though not universally__;
most frequently.
BTW it is not a case that Computer Science and *Information*
Technology are strict relat
ists to help.
BTW anyone know a DB translator pgsql<->mysql just to learn from it?
What about interesting DB abstraction layers that works with postgres
and at least 2 more other DB?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)-
hat will benefit from running on postgres.
The more hosting on pgsql, the more developer, the more applications,
the more hosting...
I can think the same in regard to python vs. php.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 6: explain analyze is your friend
('Thomas' from '...$') -> mas
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
opy csv mode. It
should works. I dealt with the same problem mmm 1 month ago.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
echnique doesn't have this problem (just others... but it
is simpler).
Any good link about DB design and how to deal with similar problems
that has some postgres spice?
thx
and yep pgsql community is great.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---
for some character before Ho.
The first Ho doesn't have a character preceding it.
The 2 other Ho have one... but it is a space and you don't want it.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Wed, 19 Dec 2007 17:24:52 +0100
Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote:
> I've something like this:
>
> create table i (
> iid serial primary key,
> name varchar(32)
> );
> create table p (
> pid serial primary key,
>
On Thu, 20 Dec 2007 09:55:29 -0600
Erik Jones <[EMAIL PROTECTED]> wrote:
>
> On Dec 20, 2007, at 8:50 AM, Ivan Sergio Borgonovo wrote:
>
> > On Wed, 19 Dec 2007 17:24:52 +0100
> > Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote:
> >
> >> I&
elds) in my
case is not completely homogeneous with the others, because it has a
double meaning.
It is cleaner to split the meanings and the data. This will even give
me a chance to avoid completely the concept of default property.
thanks, I think you put me on the rig
On Fri, 21 Dec 2007 08:19:08 +
Richard Huxton <[EMAIL PROTECTED]> wrote:
> Ivan Sergio Borgonovo wrote:
> > The default property (that is actually made by several fields) in
> > my case is not completely homogeneous with the others, because it
> > has a double me
7;BasketID'));
If not any way to make it static and avoid passing one more parameter
to the function?
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 6: explain analyze is your friend
m to insert them all in a temp table with
copy?
What about the one that have to be updated if you've all the columns,
not just the changed ones?
Is it faster to delete & insert or to update?
updates comes with the same pk as the destination table.
thx
--
Ivan Sergio Borgonovo
http
m to insert them all in a temp table with
copy?
What about the one that have to be updated if you've all the columns,
not just the changed ones?
Is it faster to delete & insert or to update?
updates comes with the same pk as the destination table.
thx
--
Ivan Sergio Borgonovo
http
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Sat, 29 Dec 2007 10:16:50 +0100
Andreas Kretschmer <[EMAIL PROTECTED]> wrote:
> Ivan Sergio Borgonovo <[EMAIL PROTECTED]> schrieb:
>
> > or/and is there something to spot what are the most critical sql
> > queries/function behind an application?
>
> You
ns accept variable number of arguments?
I'm going to go with 1) but well it would be nice if I discover
something nicer.
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 4: Have you searched our list
es without
declaring a composite type explicitly?
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Fri, 4 Jan 2008 09:38:35 +0100
Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote:
> create or replace function testA(out _BasketID1 int, out _BasketID2
> int) as $$
> begin
> _BasketID1:=1;
> _BasketID2:=2;
> return;
> end;
> $$ language plpgsql;
&
resql.
I like to have the chance of being unfaithful without needing it ;)
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
On Sun, 06 Jan 2008 02:47:17 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> Ivan Sergio Borgonovo <[EMAIL PROTECTED]> writes:
> > But when I switch to
> > select into _BasketID1,_BasketID2 _BasketID1,_BasketID2 from
> > testA(); nothing get back from testB().
&
Here it is:
>
> http://yum.pgsqlrpms.org/rpmbuildfarm.php
Cool. How do you sync the power supplies?
And thanks for the work.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 6: explain analyze is your friend
raffic shaping place "on hold" things that are already
finished in stand by slowing the whole system?
I know you can limit requests and let responses run free, but what if
they are asking back 1M record with a simple query?
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
st, src-> dest) break pk, fk
relationships and function reference to objects?
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
would you make an example of such a bad design?
Or did you just mean that count(*) is bad design in postgresql since
there are usually better alternatives in postgresql?
I'm not joking. I'd like to learn.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
ause perform generally on postgresql
compared to other DB?
I'd expect it perform as good or better than other DB since now the
bottleneck should be how efficiently it can filter records... but
still a count(*) with a where clause will incur in the same problem
of what "exact"
ess" environment where data integrity/coherence makes *a lot*
of sense it is not so clear in a CMS world where most of those
critics come from.
I know that the arguments to promote postgres in the "business" world
where DB2, Oracle and MS SQL play (?) may b
gained betting on some peculiarity of the
implementation... but in case you're dealing with a mostly static
table?
eg. if I'm importing a table does it make any sense to pre-sort it
before importing it in postgres?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
this claim is true just on cases where you could opt for a better
design
c) this claim is false for count without where clause
d) this claim is true
e) ...
details on b) would be much appreciated. Other cases require just a
yes/no answer.
thanks
--
Ivan Sergio Borgonovo
http
thinking about stuff that is in between a
mere CMS for mortals and stuff that deals with money where you don't
have budgets and hits enough to justify a complex logic to do stats
analysis or collect enough stats to make any forecast reasonable.
In this context a simpler faster even if less accurate count may be
very handy.
thanks again
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
t indexed columns and I want to trust the
indexes and I'm not concerned of the deleted rows?
Just to get an estimate between reindexing cycles, that would be
perfect for paging.
pg_class does look as returning all the rows.
--
Ivan Sergio Borgonovo
http://www.webt
On Wed, 9 Jan 2008 13:45:10 -0600
"Scott Marlowe" <[EMAIL PROTECTED]> wrote:
> But my account rep told me it was easy, and he'd never lie to me,
> would he? <@_@>
If he uses count(*) maybe, otherwise he is locking your $.
--
Ivan Sergio Bor
Considering the relative value of count my interest was for something
that is even less precise than the "usual" count but performs better.
I'm not proposing to turn Postgres into MySQL.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
ay to prevent
> accidentally returning the same row again).
Could you post a snippet of code or something giving a more detailed
idea of it?
BTW since cursors support offset if you're not interested if the
order of the retrieved rows is random too you don't even have to
remember w
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
onsider
MySQL, really, but I'm not).
As soon as I wake up from this deadline nightmare I'll definitively
try to review and propose patches to offer a better support for pg
and I'm very interested in the DB AL for 7.
And no... it is not just Karoly but there are a couple of core de
chemy to
learn.
OK... I'll stop to hijack pg list things that start to be just
tangential to postgres ;)
Many thanks to everybody who listened to the call.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 9:
s. Minor things like this can make
coding in Postgres MUCH more enjoyable.
[1] this is documented... is this aw bw bwaa behaviour of
functions documented as well?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
On Thu, 17 Jan 2008 19:07:59 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> Ivan Sergio Borgonovo <[EMAIL PROTECTED]> writes:
> > After discovering that pg_get_serial_sequence behaves in a bit
> > strange way[1] when it deals to case sensitiveness
>
> The SQL
27;d like a good Genius to fix all the issues even the
one I can barely understand and have a case preserving pg.
In reality I'll take more care with quotations and never post after
midnight.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)-
.
What about using a stored procedure to return the array as a joined
row?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
for:
update system
set weight=subselect._avg
from (
select round(avg(weight)) as _avg
from system where type='module'
) as subselect
where name='users_commerce';
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broa
ues on what's
your target to the planner that can then find a better way to
achieve it.
And yeah... on more complex statement the human can make things
worse, writing unnecessary complex sql.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)--
ed now I won't have to
change the client code later. I just would like to have an idea of
the cost of doing it now.
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ice.
My main concern when I chose the function route was limiting the
number of connections and hiding the underlying structure of the DB
to the client application.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 9
d what does not.
Yep, the more I read, the more I get confused.
Java loading overhead is a common myth (I can't say if true or false),
and what Tom writes above can find a tentative place in my mind.
But still then I can't understand where plsql should or shouldn't be
used.
tay away from sql
injection?
I'd say that queries can still be built with prepackaged static parts
and that real external input should just come in in forms of
parameters... so a DB abstraction layer or an ORM should help too...
maybe at the cost of some performance.
Otherwise you build up yo
t doesn't make too much sense working on the command line on Windows
(unless you work with monad and such... but still) since the shell is
quite limited up to my knowledge. But *nix guys may feel more
comfortable with bcp.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
http://people.planetpostgresql.org/xzilla/index.php?/archives/149-out-parameter-sql-plpgsql-examples.html#extended
Is there any difference in terms of performance and returning rows "a
bit at a time" between myuser2 and myuser3?
thanks
--
Ivan Sergio Borgonovo
http://www.webth
=7;
?
Is there anything else I can do to avoid duplication of code?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Tue, 29 Jan 2008 17:17:39 +
Sam Mason <[EMAIL PROTECTED]> wrote:
> On Tue, Jan 29, 2008 at 06:04:48PM +0100, Ivan Sergio Borgonovo
> wrote:
> > select
> > case
> > when (a>3) then a*b
> > when (a<3) then a+b
> > end as
rt
of *the* reference documentation with example output as well.
They shouldn't be of the kind "how-to" but of the kind "you can't
push the syntax further and this is what you'd expect as an output".
Many things are already there in t
for postgres in pdf
but I can't find the source.
I'm a dev not a DBA so I generally don't collect info about
management and tuning.
BTW nice drupal website. I'm looking for a drupal web designer.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---
in table.
I'll surely drop the gin index and recreate it when everything is
over.
I'm not sure if it's a good idea to drop the triggers since I'll
have to update the tsvectr later and I suspect this will cause twice
the disk IO.
thanks
--
Ivan Sergio Borgonovo
http://www.w
On Thu, 28 Oct 2010 08:58:34 -0400
Vick Khera wrote:
> On Wed, Oct 27, 2010 at 10:26 PM, Ivan Sergio Borgonovo
> wrote:
> > I'm increasing maintenance_work_mem to 180MB just before
> > recreating the gin index. Should it be more?
> >
>
> You can do this on
SBN, Name, Authors,
new.Name) where BrandID=new.BrandID;
end if;
end if;
return new;
end;
$$ language plpgsql volatile;
What could it be? how can I fix it?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, 28 Oct 2010 13:57:18 -0400
Tom Lane wrote:
> Ivan Sergio Borgonovo writes:
> > I'm running this query when I'm the only user and this should be
> > the only thing running.
>
> > And I get
>
> > DETAIL: Process 7188 waits for ShareLock on tr
n I get more information in the logs to know which statement
were producing the lock?
One for sure was the update.
> On 28 Oct 2010, at 19:28, Ivan Sergio Borgonovo wrote:
>
> > I'm running this query when I'm the only user and this should be
> > the only thing runni
On Fri, 29 Oct 2010 10:21:14 -0400
Vick Khera wrote:
> On Thu, Oct 28, 2010 at 1:06 PM, Ivan Sergio Borgonovo
> wrote:
> > What I'm planning to do is:
> > max_connections = 5
> > shared_buffers = 240M
> > work_mem = 90MB
> > maintenance_
. I know one of the statement. I'd
like to know the other.
How?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, 08 Nov 2010 15:45:12 -0500
Tom Lane wrote:
> Ivan Sergio Borgonovo writes:
> > I get
> > DETAIL: Process 24749 waits for ShareLock on transaction
> > 113443492; blocked by process 25199. Process 25199 waits for
> > ShareLock on transaction 113442820; blocked
process is running but I'm not really sure how to add a
semaphore...
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
etter solution.
Unfortunately I think the license of the above didn't help to make
people willing to improve and make the code more popular.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to y
#x27;) @@ to_tsquery('english',
'(yellow | blue) & (red | black)');
The only thing I can see that could cause problems is you may have
previously "mangled" words in the ilike query while you'd leave that
task to ts engine that will find a proper lexeme.
Could you be more specific about the problem you're encountering.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ust be superuser to COPY to or from a file.
>
> Can I do something similar to it without being superuser?
>
> for a Tab delimiter, should i use "\t" character?
The message should be longer and actually explain what to do.
you can \copy or copy from stdin.
You could find
lise the
"access points" and then once I've to refactor this I'd just use grep
for some kind of signature and fix it case by case.
But well... if I knew in advance there is a standard technique
(tool?) to build up EAV models in a way they can be "easily"
refactored, I'd be happier ;)
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
gt; I'm trying to do something similar in postgresql, can someone help
> me?
Are you referring to something like
http://www.postgresql.org/docs/8.1/static/sql-copy.html
or something like:
http://archives.postgresql.org/pgsql-php/2004-02/msg8.php
?
--
Ivan Sergio Borgonovo
http://w
I've this set of tables:
- A hold some choices made by user
- X groups A records
- B hold some other choices made by user
- C hold all the possible choices that can be put in B and
parametrised criteria when they can be chosen according to values
stored in A
something like
create table X (
id s
ich can be used to retrieve a small number of rows at a time out
of a larger query".
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Mon, 11 Feb 2008 08:46:00 -0500
"Christopher Browne" <[EMAIL PROTECTED]> wrote:
> On Feb 11, 2008 8:04 AM, Ivan Sergio Borgonovo
> <[EMAIL PROTECTED]> wrote:
> > I did manage to find an announcement about the support of pg for
> > windows... but I
te Z
Even with a disclaimer with a very bland commitment to the release
schedule it could help developers to build up their own schedule and
support list too and give some hook for advocacy as well.
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
I did manage to find an announcement about the support of pg for
windows... but I wasn't able to see anything you'd have a summary of
scheduled and planned EOL for various pg versions (on different
platform).
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
-
ally version reach EOL. If you spice it up with planned features
it would even be better.
Many people aren't used to pg "culture" and "community" and "oral
knowledge" of postgresql.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
-
On Tue, 12 Feb 2008 16:15:23 -0300
Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Ivan Sergio Borgonovo wrote:
>
> > Is it just vaporware... maybe... but still there are pros and
> > cons of having a bland schedule for EOL and new releases.
>
>
w part of "oral tradition", I think that
as much as they may seem informal they still deserve a more prominent
place and a less spread distribution.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Tue, 12 Feb 2008 11:19:19 -0500
Andrew Sullivan <[EMAIL PROTECTED]> wrote:
> On Tue, Feb 12, 2008 at 09:44:30AM +0100, Ivan Sergio Borgonovo
> wrote:
> > That's why I wrote "without making it too formal" and "bland
> > commitment to the release sch
e or some pgsql
secret weapon that could make the above plan cleaner?
I'm on 8.1.
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
e of other problems?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ckOrderID inner join shop_commerce_paytypes
pt on pm.TypeID=pt.TypeID where b.BasketID=3
I don't even know if it is worth to optimise the above till I'll have
a working comparison.
thx
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-g
1 - 100 of 520 matches
Mail list logo
