At 09:04 PM 7/14/2002, Curt Sampson wrote:
>On Thu, 11 Jul 2002, John Moore wrote:
>
> > The issue is how to prevent users from hogging the system, and especially
> > from slowing down the on-line users.
>
>Mixing OLTP and OLAP on one database server has never seemed like
atabase doesn't support it well, can generate mammoth scans
and merges.
2) Our users are mostly runing ODBC from networked (WAN'd, btw)
desktops. Thus they are immune from these policies.
Any suggestions? Any way other folks have done this (PSQL specific or just
ge
atabase doesn't support it well, can generate mammoth scans
and merges.
2) Our users are mostly runing ODBC from networked (WAN'd, btw)
desktops. Thus they are immune from these policies.
Any suggestions? Any way other folks have done this (PSQL specific or just
ge
act.
Thanks in advance
John Moore
http://www.tinyvital.com/personal.html
UNITED WE STAND
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
elves.
Thanks in advance.
John Moore
http://www.tinyvital.com/personal.html
UNITED WE STAND
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
me
At 04:49 PM 7/4/2002, Tom Lane wrote:
>John Moore <[EMAIL PROTECTED]> writes:
> > So I *suspect* I want to keep the data in the physical row, rather than
> > using TEXT and having it stored separately from the record.
>
>You seem to be reading something into the
>If you don't want a limit, use TEXT. Long values are automatically
>stored in TOAST tables to avoid performance problems with sequential
>scans over long row values.
Thanks...
I wasn't quite clear enough in my question I am focused on OLTP
performance, and in my case the vast majority o
We hope to use views as a way to give customers odbc based ad-hoc query
access to our database while enforcing security. The reason is that we do
not want to put data into separate tables by customer, but rather use a
customer ID as part of any query criteria on any table.
So the question is:
act.
Thanks in advance
John Moore
http://www.tinyvital.com/personal.html
UNITED WE STAND
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
