per
>> database, etc.)
>> --
>> Mike Nolan.
>>
>
> I don't think the number of tuples is the main problem here, it's the
> number of pages a single relation can have. Looking at the numbers of rows
> as a direct function of TID size is misleading, beca
ng a 64
bit row pointer be possible? That would give you 2^64 or 1.8 E19 unique
rows over whatever granularity/uniqueness you use (per table, per database,
etc.)
--
Mike Nolan.
Why not take a simpler approach and create a zero length file in
directories that should not be fiddled with by non-experts using a file
name something like "DO.NOT.DELETE.THESE.FILES"?
No, it won't prevent the incredibly stupid from doing incredibly stupid
things, nothing will.
--
Mike Nolan
inux-gnu, compiled by gcc
(GCC) 4.1.2 20070925 (Red Hat 4.1.2-27), 32-bit'
DBNAME = 'postgres'
USER = 'postgres'
PORT = '5432'
ENCODING = 'UTF8'
postgres=#
--
Mike Nolan
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
e we removed them.
FWIW, the documentation for 9.2 still mentions OIDs and the
'default_with_oids' parameter, in what release was it announced they
would be removed and in what release were they removed?
--
Mike Nolan
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.o
eate M*N sockets.
>
> I don't really see a problem with that.
>
What about entries in pg_hba.conf? Will they need to be able to specify
both the directory and the port number?
--
Mike Nolan
, okay, but let's document "if you use this feature, it's incumbent
> on you to make sure the master and slave clocks are synced. We
> recommend running NTP." or words to that effect.
What if the two servers are in different time zones?
--
Mike Nolan
--
Sent via pgsq
ause to override any errors, but it probably isn't something most DBAs
would run into very often.
Thanks for figuring it out, Tom.
--
MIke Nolan
On 5/11/12, Michael Nolan wrote:
> On 5/11/12, Albe Laurenz wrote:
>> Michael Nolan wrote:
>>> I see one potential difference between your results and mine.
>>>
>>> When I rebuild the tablespace, I wind up with the same filename/OID as
>>> before, I&#
On 5/11/12, Albe Laurenz wrote:
> Michael Nolan wrote:
>> I see one potential difference between your results and mine.
>>
>> When I rebuild the tablespace, I wind up with the same filename/OID as
>> before, I'm not sure you do.
>
> Right. That's stra
I see one potential difference between your results and mine.
When I rebuild the tablespace, I wind up with the same filename/OID as
before, I'm not sure you do.
--
Mike Nolan
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
that.
I get the same results whether I rebuild the specific index as you did
or reindex the table, as I did.
I'm running on 9.1.3 built from the source code, not a distribution.
--
Mike Nolan
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
to suggest how to repair, because the lost
tablespace only had indexes in it. But that's not exactly a -hackers
issue, more of a question of better backup protocols.
--
Mike Nolan
index on MYTABLE. Queries will work on this table again, as
expected.
Now, here's the problem I ran into:
The index will be rebuilt in tablespace MYTBLSP, but \d on table MYTABLE
will not show the index as being in that tablespace.
--
Mike Nolan
temporary tables might be needed at the system
level (if not already available) in order to prepare more efficient plans
for some complex read-only queries.
--
Mike Nolan
a commit), why are they replicated at all?
BTW, should we have an entry in the index for 'temporary tables?
--
Mike Nolan
e with synchronous replication? If it
fails, what's the appropriate action to take on the master? PANICing
it seems to be a bad idea, but having transactions never complete
because they never hear back from the synchronous slave (for whatever
reason) seems bad too.
--
Mike Nolan
--
Sent vi
On 4/11/12, Kevin Grittner wrote:
> Michael Nolan wrote:
>> On 4/11/12, 乔志强 wrote:
>
>>> But when a transaction larger than 1GB...
>>
>> Then you may need WAL space larger than 1GB as well. For
>> replication to work, it seems likely that you may need to
replication cannot be achieved, although
that might have negative consequences as well.
> Another question:
> Does master send WAL to standby before the transaction commit ?
That's another question for the core team, I suspect. A related
question is what happens
if there is a rollback?
-
On Tue, Sep 13, 2011 at 2:55 PM, Joshua D. Drake wrote:
>
> On 09/13/2011 11:51 AM, Michael Nolan wrote:
>
>
>>The ability to restore a table from a backup file to a different
>>table
>>name in the same database and schema.
>>
>>
&
On Tue, Sep 13, 2011 at 12:26 PM, Joshua D. Drake wrote:
>
> On 09/13/2011 10:13 AM, Michael Nolan wrote:
>
>> The lists all seem to be focusing on the things that the developers
>> would like to add to PostgreSQL, what about some things that users or
>> ISPs might lik
totals. (SqlPlus
has this, even though it isn't very pretty.)
--
Mike Nolan
e
database, even if that is what schemas are for.
The ability to do cross-database (most likely cross-server as well) queries
would address a lot of real-world problems.
-
Mike Nolan
no...@tssi.com
it the last day of that month, and apply it to the
output of generate_series();
--
Mike Nolan
no...@tssi.com
TB to get up to speed would be appreciated, though I
still think it is not just a 'caching' issue.
The question I hesitated to ask in Ottawa was: So, what information would
you like and what would you do with it?
--
Mike Nolan
different plans (and thus actual performance), based on what
has happened recently,
so these statistics would have to be relatively short term and updated
frequently, but without becoming
computational bottlenecks.
The problem is one I'm interested in working on.
--
Mike Nolan
e.
Insert emphatic agreement here. Refactoring into smaller functions or
doing a bit of object orientation almost always solves that readability
problem for me.
--
Nolan Cafferky
Software Developer
IT Department
RBS Interactive
[EMAIL PROTECTED]
that suggests to the query writer that they did something wrong.
--
Nolan Cafferky
Software Developer
IT Department
RBS Interactive
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: explain analyze is your friend
I received the following note from the original author of dbf2pg:
> Date: Tue, 05 Aug 2003 18:43:22 +0400
> From: Maarten Boekhold <[EMAIL PROTECTED]>
> Subject: Re: status of dbf2pg
> To: [EMAIL PROTECTED]
>
> On 08/03/2003 06:55:01 AM nolan wrote:
> > What is t
he package
([EMAIL PROTECTED]) with no response, but maybe that's an
old address.
--
Mike Nolan
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
the gaps in my knowledge.
Just part of the baptism of fire for a newbie, I guess. :-)
--
Mike Nolan
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
ke cvs update behave reasonably ... I have no idea
> why they are not the default behavior.
Yep, that solved both the make clean and the coredump problems.
Is that piece of information in the developers FAQ anywhere?
--
Mike Nolan
---(end of broadcast)--
More problems with the latest CVS on FreeBSD:
make[3]: Leaving directory `/home/nolan/beta/pgsql/contrib/spi'
/bin/sh ./pg_regress --temp-install --top-builddir=../../.. --schedule=./paralle
l_schedule --multibyte=SQL_ASCII
== removing existing temp install
Make clean fails on an up-to-date CVS (as of 2:40 PM CDT on Sunday).
Here's the final part of the output:
make[2]: Leaving directory `/home/nolan/beta/pgsql/contrib/tablefunc'
make[2]: Entering directory `/home/nolan/beta/pgsql/contrib/tips'
make[2]: Nothing to be done for
Sorry if I didn't mention it before, but this was on FreeBSD.
--
Mike Nolan
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
> This allows functions to read/write operating system files. Is this of
> interest to anyone?
Is this something that requires untrusted status, as it would if I
wrote a function in perl to do the same thing?
--
Mike Nolan
---(end of bro
urse, the sooner you get it in
> the more likely we'll see it that way ;-). Later in beta, only critical
> bugfixes will be accepted, and this one surely ain't very critical.
Now if I can just get CVS working on Redhat 8 and remember how to build
a patch, even a one-li
ix or a
specification change, a question which is relevant since we're in the
feature freeze for 7.4.
--
Mike Nolan
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
7;.
No, it doesn't change the 'y' to an 'i', that's a typo in my earlier
note. As far as I can tell, not capitalizing the first letter after a dash
is the only inconsistency with Oracle's implementation of this function.
If a patch is in order at this time, I wil
hange to oracle_compat.c in
backend/utils/adt, but is this a bugfix that can be made during the
pre-beta period for 7.4 or does it need to wait?
--
Mike Nolan
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
that is an absolute.
> I have no idea what is the status of that effort right now. You can search the
> archives or I hope this kicks a fresh discussion..:-)
I'm game, though I'm also not ready to lead such a project, probably not
even the discussion on it.
--
Mike Nolan
> I thought Tablespaces were already implemented. Are they not?
Apparently not.
A group has been formed to work on it, though.
--
Mike Nolan
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
e appears to have a
couple of other places where intermingling to stdout is possible,
especially if readline is used.
Throwing in "system('sleep 1');" was the way I resolved the timing
question here, but that may not be portable enough for inclusion into
the code base.
--
M
rtable nor does it ENSURE completion.
What's the proper way to do this? And what's a good book on writing
portable code?
--
Mike Nolan
---(end of broadcast)---
TIP 8: explain analyze is your friend
underestimating the pervasiveness of
implementing tablespaces.
--
Mike Nolan
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
iles from just ONE database permitted in any given
tablespace, and ONLY files from that database. The former is probably
a good thing to require and enforce, the latter is unenforcable but
probably still advisable.
Is this doable within the time frame for the 7.4 featu
database.schema.object,
not tablespace.database.schema.object or database.tablespace.schema.object.
--
Mike Nolan
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
;d suggest something like setting ECHO to 'queryout'. To be complete,
would it need to have a command line equivalent, too?
BTW, I figured out how to direct the output to a separate file each time,
I put the following in .psqlrc:
\o |tee `echo psql_${$}.txt`
--
Mike
in any case, and it's not an itch
> I feel personally. Work on it yourself if you want it ...
I'm trying to, now I really feel like a rookie! :-)
--
Mike Nolan
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
me a running record of what I did when, which saves me a LOT
of time if I want to view the results of some query I ran last week.
I can delete or zip up files if I get short on disk space space
--
Mike Nolan
---(end of broadcast)---
TIP 9: the pl
lly they could all point to the same place:
SYSTEM
USER
TEMP
INDEXES
What about the concepts of a 'read-only' tablespace, or taking tablespaces
offline?
--
Mike Nolan
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
51 matches
Mail list logo
