"Alexander Priem" <ap(at)cict(dot)nl> writes:
> What I am thinking about is creating two views for this table: Table_View a=
> nd Table_History. Table_View would contain all records where "Deleted is nu=
> ll". Table_History would just contain all records (Select * From Table).
> Would " Select * from Table_View Where Name=3D'xxx' " perform worse than " =
> Select * from Table Where deleted is null and Name=3D'xxx' " ?
They'd be exactly the same (modulo a few extra microseconds/milliseconds
for the query planner to expand the view definition).
regards, tom lane