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 will
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
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
understood
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 NUMERIC );
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, this could be used instead of a
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 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, no.
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
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 Oracle