[GENERAL] oracle listener intercept

Hi,I'm looking at replacing an Oracle database that only has a few tables, but that is accessed by many programs in the company via oracle jdbc drivers, oracle odbc drivers and python database interface. Is there a way to intercept the calls to the oracle listener and redirect to postgres without c

Re: [GENERAL] ident authentication with named localhost

Tom Lane wrote: David Link <[EMAIL PROTECTED]> writes: Does anyone know how I can test ident? I'd try sniffing the IP traffic to and from it with a packet sniffer and/or tracing the daemon's system calls with strace. Manually invoking the daemon isn't going to

[GENERAL] ident authentication with named localhost

but what's the client port to give? Any and all help greatly appreciated. Thanks. David Link ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTE

Re: [GENERAL] EXPLAIN SELECT .. does not return

Tom Lane wrote: David Link <[EMAIL PROTECTED]> writes: The following large EXPLAIN SELECT Statement fails to return, but continues to take up processing time until it is killed. [ 52-way join... ] Am I right in guessing that all the sales_xxx tables are the same size and have s

[GENERAL] EXPLAIN SELECT .. does not return

neral/2005-12/msg00259.php Any and all help, greatly appreciated. Thank you. David Link, White Plains, NY Environment: Linux 2.6.5-7.191 SMP Postgresql 7.4.8 Database size: 110 Gb on disk. vacuum analyze done Processes: postgres 15687 1 0 16:12 pts/100:00:00 /usr/bin/postmaster -D

Re: [GENERAL] EXPLAIN SELECT .. does not return

Tom Lane wrote: David Link <[EMAIL PROTECTED]> writes: Certain SQL Queries, I believe those with many table joins, when run as EXPLAIN plans, never return. I'd guess that one or all of these settings are excessive: geqo_threshold = 14 from_collapse_limit = 13 join_col

Re: [GENERAL] EXPLAIN SELECT .. does not return

Jaime Casanova wrote: when you have thoses cases, you can take a look in pg_stats_activity to find the offending query... or simply logs all queries Thanks for the advice. I also turned on stat_command_string ---(end of broadcast)--- TIP 3:

[GENERAL] EXPLAIN SELECT .. does not return

Hi, This has become a major problem for us. Thank you in advance for your help. OS: SUSE Linux 2.6.5-7.191-bigsmp PostgreSQL: 7.4.8 Application: ModPerl Web application using DBI.pm Database size: 100 Gb, 1025 Tables. Problem: EXPLAIN SELECT ... does not return. Description: The Application

[GENERAL] Question about backing up partial Database

ip sales_2001_dump.gz Currently all the tables are in the public namespace. We've had trouble in the past for our perl program to work with multiple schema names. Thank you for your help any suggestions. Sincerely, David Link White Plains, NY --

Re: [GENERAL] diskspace usage recovered on db rebuild

Thank you Scott and Lonni for your replies ... On Fri, 2005-04-01 at 11:21, David Link wrote: I have a question regarding filesystem disk space usage. We have a production database containing 5 years of sales data. Linux 2.6.5; Postgresq 7.4.7. VACUUM ANALZYE the entire database everynight

[GENERAL] diskspace usage recovered on db rebuild

ut 66 Gigabytes on disk. When I rebuild the database (using pg_dump and pgsql ), the new resultant database is .. About 48 Gigabytes on disk. A 27% space savings. Can someone tell me why that is? Thank you, David Link White Plains, NY Long live Postgres. ---(end of broa

Re: [GENERAL] A conditional DROP TABLE function

Hi Tino, --- Tino Wildenhain <[EMAIL PROTECTED]> wrote: > David Link wrote: > > Hi All, > > > > Here's a Conditional drop_table func for those interested. There > was a > > thread on this a long time back. > > > > We do this all the tim

[GENERAL] A conditional DROP TABLE function

Hi All, Here's a Conditional drop_table func for those interested. There was a thread on this a long time back. We do this all the time : DELETE TABLE sales; CREATE TABLE sales (...); But nobody likes ERROR: table "sales" does not exist which we see all the time in the logs. I want t

Re: [GENERAL] Why does adding SUM and GROUP BY destroy performance?

Thanks Ron, Thanks Christopher for your excellent feedback. I guess it's back to the drawing board. This is a very late hour business requirement change. And we need quick real-time results. Two things are being considered: 1. loading the non aggregate query entirely into memory (using perl

[GENERAL] Why does adding SUM and GROUP BY destroy performance?

Hi, Why does adding SUM and GROUP BY destroy performance? details follow. Thanks, David Link s1.sql: SELECT t.tid, t.title, COALESCE(s0c100r100.units, 0) as w0c100r100units, (COALESCE(r1c2r100.units, 0) + COALESCE(y0c2r100.units, 0)) as r0c2r100units

[GENERAL] Understanding explain costs

rw---1 postgres postgres 1073741824 Oct 11 13:13 bk_inv_store_idx -rw---1 postgres postgres 65921024 Oct 11 13:13 bk_inv_store_idx.1 Am I missing certain fundamentals about the planner/executor? Thanks, David Link ---(end of broadcast)---

[GENERAL] Performance problem with 50,000,000 rows

idx on bk_inv (cost=0.00..225.53 rows=55 width=48) Note. Same tables, same query returns instantaneously with Oracle 8.1. What I am hoping to show is that Postgres can do our job too. Any help on this much obliged. (Yes I ran vacuum analyze). David Link White Plains, NY