ly be done in a
time frame
like above (last three year, next three years). If a recurring event gets
altered,
all its serialized events need to be updated.
Any feedback?
Thomas Güttler
--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de
--
Sent
On 07.06.2011 09:57, Vincent Veyron wrote:
> Le lundi 06 juin 2011 à 12:59 +0200, Thomas Guettler a écrit :
>
>> how do you store recurring events in a database?
>>
>> Selecting all events in a week/month should be fast (comming from an index).
>>
>> My s
Hi Craig and mailing list
On 07.06.2011 00:54, Craig Ringer wrote:
> On 06/06/2011 06:59 PM, Thomas Guettler wrote:
>> Hi,
>>
>> how do you store recurring events in a database?
>
> I use two tables: one table that stores the recurring event, and another
> that
Release 9.2 should increase count(*) performance. Is this wiki page still valid?
http://wiki.postgresql.org/wiki/Slow_Counting
Please update the content.
Thank you,
Thomas Güttler
--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de
--
Sent via
group by c_id) as X
> on C.id = X.c_id
>
> All the fields mentioned are indexed. In the case of Table C it's the
> primary key. In the case table E it's just an index (non unique).
>
> I let this query run for about three hours before I c
in separate files.
>
> User can pick items, enter quantities and send order which is stored
> in database.
>
> Any idea where to find source code for this ?
>
> Andrus.
>
--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de
--
Sent via
p://en.wikipedia.org/wiki/Database_transaction)
HTH,
Thomas
--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
here.
There are a lot of django friendly hosting companies:
http://code.djangoproject.com/wiki/DjangoFriendlyWebHosts
And a virtual root server does not cost much.
Thomas
--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de
--
Sent via pgsql-general mailing list (pgsql
DB, restore data
only from dump.
- Use alter table.
- Use a tool like apgdiff (never tried it).
I guess all ways will be possible. But what do you suggest?
Thomas
--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de
--
Sent via pgsql-general mailing
tion:
cat update--MM-DD.sql | psql
See http://www.djangosnippets.org/snippets/1160/
David Fetter schrieb:
> On Thu, Oct 30, 2008 at 10:54:46AM +0100, Thomas Guettler wrote:
>
>> Hi,
>>
>> is there a schema upgrade howto? I could not find much with google.
>>
>
Thomas Güttler
--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
(eg ALTER TABLE to add a column) get added to the patch
script. ...
--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mail
Am 13.04.2012 20:35, schrieb Scott Marlowe:
On Thu, Apr 12, 2012 at 2:16 AM, Thomas Guettler wrote:
Hi,
I think it would be very good, if postgresql reports which column is too
small:
Value to long for type character varying(1024) (message translated from
german to english)
Is there a
00..27278.09 rows=5132 width=16) (actual
time=0.327..61.911 rows=43 loops=1)
Filter: (NOT (subplan))
SubPlan
-> Index Scan using detail_master_id on detail d
(cost=0.00..50.16 rows=19 width=0) (actual time=0.004..0.004 rows=1
loops=10269)
Index Cond: (master_id = $0)
T
Peter Eisentraut <[EMAIL PROTECTED]>Peter Eisentraut schrieb:
> Thomas Guettler wrote:
>> My naive first solution was quite slow. Why is it so slow?
>> I guess (select d.master_id from detail as d) gets executed for every
>> master-row. But why? Shouldn't
>&g
o stay with the defaults (SuSE).
How do you check your logfiles?
Thomas Güttler
--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www
btree (id)
»foo_abc_abc_lieferant« btree (lieferant)
..
version
--
PostgreSQL 8.2.4 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.2
20061115 (prerelease) (SUSE Linux)
(1 Ze
# select version();
version
PostgreSQL 8.2.6 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.2.1
(SUSE Linux)
(1 Zeile)
Tom Lane schrieb:
> Thomas Guettler writes:
>> why does the statement
Hi,
how can you get N numbers (without holes) from a sequence?
Thomas
--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
hubert depesz lubaczewski schrieb:
> On Tue, May 19, 2009 at 01:45:17PM +0200, Thomas Guettler wrote:
>> how can you get N numbers (without holes) from a sequence?
>
> alter sequence XXX increment by 1000;
> select nextval('XXX');
> alter sequence XXX incremen
Boszormenyi Zoltan schrieb:
> Thomas Guettler írta:
>> Hi,
>>
>> how can you get N numbers (without holes) from a sequence?
> # create sequence tmp_seq cache 1000;
Hi,
"alter SEQUENCE ... cache 100" survives a rollback. That's something I like t
Thomas Guettler schrieb:
> Hi,
>
> how can you get N numbers (without holes) from a sequence?
>
If sequences could be locked like tables, it would be easy.
In old versions of postgres it worked:
http://archives.postgresql.org//pgsql-hackers/2001-10/msg00930.php
Thomas
24 matches
Mail list logo
