Hi,
On Mon, Oct 03, 2005 at 08:14:11AM -0700, [EMAIL PROTECTED] wrote:
> So my questions are:
> * Does anyone have any idea how I can integrate a function that lists
> all aliases for a given name into such a mapping query?
what version are you using?
TIP 9: In versions below 8.0, the planner wi
Hi,
On Thu, Jun 09, 2005 at 02:11:22PM +0100, Richard Huxton wrote:
> >
> >To my question: I found the parameter "stats_reset_on_server_start"
> >which is set to true by default. Why did you choose this (and not false)
> >and what are the impacts of changeing it to false? I mean, as long as I
> >u
Hi,
after having migrated a 7.2 pg-database to 7.4 while upgrdaing from
debian woody to debian sarge there are some more conf-Parameters to
evaluate.
We are running a small but continuously growing datawarehouse which has
recently around 40 million fact entries.
To my question: I found the para
Hi,
On Sun, Mar 20, 2005 at 06:01:49PM -0500, Tom Lane wrote:
> Global indexes would seriously reduce the performance of both vacuum and
> cluster for a single partition, and if you want seq scans you don't need
> an index for that at all. So the above doesn't strike me as a strong
> argument for
Hi,
On Fri, Jan 21, 2005 at 03:37:20PM +0100, Matteo Beccati wrote:
>
> CREATE TABLE super_foo ( partition NUMERIC, bar NUMERIC );
> ANALYZE super_foo ;
>
> CREATE TABLE sub_foo1 () INHERITS ( super_foo );
> CREATE TABLE sub_foo2 () INHERITS ( super_foo );
> >
> >Yes, thi
Hi,
On Fri, Jan 21, 2005 at 09:50:46AM +0100, Matt Casters wrote:
>
> > Some people have been doing it using a union view. There isn't actually
> > a partition feature.
>
> Actually, there is. If found this example on pgsql-performance:
>
> >> CREATE TABLE super_foo ( partition NUMERIC, bar
Hi,
On Mon, Jan 10, 2005 at 11:07:55AM -0500, Alex Turner wrote:
> Neither Oracle nor MS-SQL have the range of stored procedure langauges
> that Postgresql supports.
That is not true. Oracle uses PL/SQL for its stored procedures and
M$-SQL does have a stored procedural language.
Regards,
Yann
Hi
On Thu, Jan 06, 2005 at 12:51:14PM -0500, Rod Taylor wrote:
> On Thu, 2005-01-06 at 12:35 -0500, Dave Cramer wrote:
> > Reading can be worse for a normalized db, which is likely what the
> > developers were concerned about.
>
> To a point. Once you have enough data that you start running out
Hi,
On Tue, Jan 04, 2005 at 10:06:18AM -0800, Josh Berkus wrote:
> > are there any plans for rewriting queries to preexisting materialized
> > views? I mean, rewrite a query (within the optimizer) to use a
> > materialized view instead of the originating table?
>
> Automatically, and by default,
Hi,
are there any plans for rewriting queries to preexisting materialized
views? I mean, rewrite a query (within the optimizer) to use a
materialized view instead of the originating table?
Regards,
Yann
---(end of broadcast)---
TIP 6: Have you sea
Hi,
On Wed, Dec 22, 2004 at 01:52:40PM -0800, Litao Wu wrote:
> Does the order of columns in the index matter since
> more than 50% customer_id = 158?
>
> I think it does not in Oracle.
>
> Will the performance be better if I change index
> xxx_idx to ("domain", customer_id, created)?
Well, in
11 matches
Mail list logo
