Hi All,
I am on postgres 9.0. I don't know the answer to what should be a fairly
straight forward question. I have several static tables which are very
large (around the order of 14 million rows and about 10GB). They are all
linked together through foreign keys and indexed on rows which are querie
reSQL already has the ability to do this as it seems very useful to
manage very large data sets.
Thanks,
~Ben
On Fri, Jun 15, 2012 at 2:42 PM, John R Pierce wrote:
> On 06/15/12 11:34 AM, Benedict Holland wrote:
>
>> I am on postgres 9.0. I don't know the answer to what should b
many small indexes?
Thanks,
~Ben
On Sat, Jun 16, 2012 at 2:13 AM, Gabriele Bartolini <
gabriele.bartol...@2ndquadrant.it> wrote:
> Hi Benedict,
>
> Il 15/06/12 20:58, Benedict Holland ha scritto:
>
> The tables would have to be specified with a table pk constraint falling
>
Hi All,
I am scratching my head over this one. I have a basic function which
populates a table inside of it (declared outside of the function but that
shouldn't matter) and it requires something like
insert into table1 (col1, ...)
select * from foo
and I get the error "query has no destination
PM, Tom Lane wrote:
> Benedict Holland writes:
> > I am scratching my head over this one. I have a basic function which
> > populates a table inside of it (declared outside of the function but that
> > shouldn't matter) and it requires something like
>
> > insert into t
Hi All,
This one is confusing. The only difference in my db is that it comes from a
user specific template not pg_default.
I run this:
***
cr
Oh heck. Yes, I misread avg(expression as ave. Sorry for this.
~ben
On Tue, Jul 3, 2012 at 2:13 PM, hubert depesz lubaczewski wrote:
> On Tue, Jul 03, 2012 at 02:07:54PM -0400, Benedict Holland wrote:
> > This one is confusing. The only difference in my db is that it comes
> fro
