On Sun, Jun 10, 2007 at 06:40:19PM +0200, Andrej Kastrin wrote:
> A. Kretschmer wrote:
> >am Sun, dem 10.06.2007, um 13:41:27 +0200 mailte Andrej Kastrin folgendes:
> >
> >>Dear all,
> >>
> >>I need to count all pairs of instances which occure under given ID
> >>number, e.g.:
> >>
> >>ID word
>
On Jun 10, 2007, at 2:14 PM, Joe Conway wrote:
Bill Moran wrote:
Tom Allison <[EMAIL PROTECTED]> wrote:
If the user base gets to 100 or more, I'll be hitting a billion
rows before too long. I add about 70,000 rows per user per day.
At 100 users this is 7 million rows per day. I'll hi
On Jun 10, 2007, at 15:28 , Ottavio Campana wrote:
Can I do it directly in postgresql, or do I have to use some external
programs (cron?) ?
Use cron or some similar tool.
Michael Glaesemann
grzm seespotcode net
PGP.sig
Description: This is a digitally signed message part
On 6/10/07, Ottavio Campana <[EMAIL PROTECTED]> wrote:
I want to execute a function automatically every day, let's say at midnight.
Can I do it directly in postgresql, or do I have to use some external
programs (cron?) ?
Thanks.
you have to use an external program (cron is good)
--
regards,
I want to execute a function automatically every day, let's say at midnight.
Can I do it directly in postgresql, or do I have to use some external
programs (cron?) ?
Thanks.
--
Non c'e' piu' forza nella normalita', c'e' solo monotonia.
signature.asc
Description: OpenPGP digital signature
Bill Moran wrote:
Tom Allison <[EMAIL PROTECTED]> wrote:
If the user base gets to 100 or more, I'll be hitting a billion rows before too
long. I add about 70,000 rows per user per day. At 100 users this is 7 million
rows per day. I'll hit a billion in 142 days, call it six months for simpl
Tom Allison <[EMAIL PROTECTED]> wrote:
>
> I've started a database that's doing wonderfully and I'm watching the tables
> grow and a steady clip.
>
> Performance is great, indexes are nice, sql costs are low. As far as I can
> tell, I've done a respectable job of setting up the database, tables
A. Kretschmer wrote:
am Sun, dem 10.06.2007, um 13:41:27 +0200 mailte Andrej Kastrin folgendes:
Dear all,
I need to count all pairs of instances which occure under given ID
number, e.g.:
ID word
-
1 car
1 fruit
2 car
2 fruit
2 vegetable
3 car
3 vegetable
And
On 6/10/07, Tom Allison <[EMAIL PROTECTED]> wrote:
The table itself is small (two columns: bigint, int) but I'm wondering when I'll
start to hit a knee in performance and how I can monitor that.
You don't say anything about what the data is in the table or what
queries you run against it, so th
I've started a database that's doing wonderfully and I'm watching the tables
grow and a steady clip.
Performance is great, indexes are nice, sql costs are low. As far as I can
tell, I've done a respectable job of setting up the database, tables, sequence,
indexes...
But a little math tells
On Sat, Jun 09, 2007 at 07:40:05PM -0400, ABHANG RANE wrote:
> Hi,
> I had some doubts about the gist index on cube column. So if I have a
> column of type cube and create a gist index on it, would the index be
> on individual elements in the cube or the cube as a whole. I mean will
> a gist ind
am Sun, dem 10.06.2007, um 13:41:27 +0200 mailte Andrej Kastrin folgendes:
> Dear all,
>
> I need to count all pairs of instances which occure under given ID
> number, e.g.:
>
> ID word
> -
> 1 car
> 1 fruit
> 2 car
> 2 fruit
> 2 vegetable
> 3 car
> 3 vegetable
>
> A
Dear all,
I need to count all pairs of instances which occure under given ID
number, e.g.:
ID word
-
1 car
1 fruit
2 car
2 fruit
2 vegetable
3 car
3 vegetable
And the output should be simillar to:
car fruit 2
car vegetable 2
fruit vegetable 1
Any suggestion how t
13 matches
Mail list logo
